AutoHotkey Community

Tomer

@ahk7
Thanks for the explanation!

Tomer

If this is the actual file format DisplayName,Username,Office,SNIFSITECODE,ComputerName,IPAddress,Date,Time,OSVersion,SESSIONNAME,SentCount Mike,Mike1,London,None,TESTPC,10.254.50.6,21\01\2021,16:38:16,WIN_7,console,1 Mike,Mike1,London,None,TESTPC,10.254.50.6,21\01\2021,16:38:16,WIN_7,console,2 and...

Tomer

find = 10.254.50.6 count := StrSplit(TF_Find(text,,, "^" StrReplace(find, ".", "\.") "$", 0, 0), ",").Count() MsgBox, 64, Results for %find%, %count% Nice! 2 things to resolve please: 1. when there nothing was found - the result is still "1" which should be "0" 2. i changed the file format and i wa...

Tomer

I thought that you wanted a boolean result. Below is a line count. find = 10.254.50.6 MsgBox, 64, Count for %find%, % lineCount(text, find) lineCount(str, find) { StrReplace("`n" str "`r", "`n" find "`r",, count) Return count } works very well, thanks! i will still not accept this answer in forum o...

Tomer

Possibly something like: WordCount := TF_Count(TF("Test_TestFile.txt", "WordCount") "\D" ,"10.254.50.6") > 0 Also: find = 10.254.50.6 found := Instr("`n" text, "`n" find) > 0 MsgBox, 64, Result for %find%, % found ? "True" : "False" Nice try @mikeyww but its still fail to count correctly, try with ...

Tomer

tf.ahk How to use \D toggle for EXACT match so the correct result will be 1 and not 3 ? Thanks in advance! #Include tf.ahk text= (join`r`n 1 2 3 4 10.2.10.2 10.254.50.60 10.254.50.61 10.254.50.6 10.10.10.10 10.2.1.100 ) FileDelete, Test_TestFile.txt FileAppend, % text, Test_TestFile.txt WordCount:=...

Tomer

Thanks @garry but there not could be more than 1 same active user i need to get in a msgbox only the SESSIONNAME of the active user without any other text without any spaces or tabs. see my sample txt file in last post (editted) thanks! edit: may this will do the job: f1=%a_scriptdir%\querytest.txt ...

Tomer

@garry can you replace it by the STATE "Active" instead of the USERNAME "test_user" to get the current SESSIONNAME ? Sample of txt file to read f1=%a_scriptdir%\querytest.txt ifexist,%f1% FileDelete,%f1% FileAppend, ( USERNAME SESSIONNAME ID STATE IDLE TIME LOGON TIME 12345678 1 Disc 21:10 19/01/202...

Tomer

Thank you both!

Tomer

i want to get in a msgbox only the SESSIONNAME of the user "test_user", in my sample code i managed to get only the entire line, any help would be appreciated. p.s - the sample txt file in the code is dynamist, more lines of users can appear. FileDelete, c:\temp\querytest.txt FileAppend, ( USERNAME ...

Tomer

Well, there is https://github.com/hi5/TF#TF_Count but as you will have seen it doesn't support files only variables (strings). But we can make use of TF() https://github.com/hi5/TF#TF to read the contents of a file into a variable and use that - see also section underneath "Introduced in v3: TF()" ...

Tomer

hello,

i have a txt file with some same words,
i want to count only these words to a number

file contanis:

1
2
3
4
4
4
5
6
7

i want to count how many "4" i have in the file,

result should be 3

Tomer

my final code thanks to @Xtra & @mikeyww #NoEnv SetBatchLines, -1 FileDelete, c:\csvfile.csv FileDelete, c:\new_csvfile.csv ; sample of csv file FileAppend, ( From: dsadasdas <dsadasd>,,,,,,,,,,,,, "Sent: Sunday, April 07, 2019 10:22 AM",,,,,,,,,,,,, To: dasdsadsada‏ <adsadasdas>; Tsdadi‏ <dasdasda>...

Tomer

mikeyww wrote: ↑
25 Oct 2020, 16:42
You can replace the Instr line with whatever condition identifies your lines of interest. It might be like the following.
Code: Select all
If RegExMatch(Line, "^\d+?,")
You can decide based on whatever sort of text you are handling.

it works tnx !

Tomer

mikeyww wrote: ↑
25 Oct 2020, 16:05
@Xtra always gives you extra.

Sure!
Thanks for your code share,
its really impressive!

Tomer

Thanks Xtra its perfect ! Edit: its still not handle this for example: ; sample of csv file FileAppend, ( From: dsadasdas <dsadasd>,,,,,,,,,,,,, "Sent: Sunday, April 07, 2019 10:22 AM",,,,,,,,,,,,, To: dasdsadsada‏ <adsadasdas>; Tsdadi‏ <dasdasda>,,,,,,,,,,,,, Subject: dasdasdas,,,,,,,,,,,,, ,,,,,,,...

Tomer

Thanks Xtra !
but i get:
"This line does not contain a recognized action."

Tomer

Thanks mikeyww! its works fine! problem is the the original csv i work with sometimes have more text outside the "table" at the beginning and end of the csv, so the files csv looks like this: FileAppend, ( text1 text2 text3 text4 text5 ID,SN,Type,Model,Model Company,Address,Adress2,Room,Username,IT ...

Tomer

i need help with getting only the values of the columns "ID" and "CompanyID" in each row to a new csv file. so according to my sample code the outcome of the new csv file should be: 1. 210269, SC12345678910 2, 210271, 456123 notes: * the row numbers not constant * csv file may have more than 2 rows ...

Tomer

Edit:

Thanks !
works like a charm!

using 65001 ( Unicode (UTF-8) )

Search found 336 matches

Re: Help with library: TF.ahk

Re: Help with library: TF.ahk

Re: Help with library: TF.ahk

Re: Help with library: TF.ahk

Re: Help with library: TF.ahk

Help with library: TF.ahk

Re: Help with reading a file Topic is solved

Re: Help with reading a file Topic is solved

Re: Help with reading a file Topic is solved

Help with reading a file Topic is solved

Re: [library] TF: Text files & Variables (strings) v3.8

Re: [library] TF: Text files & Variables (strings) v3.8

Re: Help with reading csv file Topic is solved

Re: Help with reading csv file Topic is solved

Re: Help with reading csv file Topic is solved

Re: Help with reading csv file Topic is solved

Re: Help with reading csv file Topic is solved

Re: Help with reading csv file Topic is solved

Help with reading csv file Topic is solved

Re: Help with FileEncoding Topic is solved