Find a certain number in a txt file ?

[doa]

Hello all,

how to find a number in a lines (I used “Separate>file1,CRLF,linesâ€

[Marcus Tettmar]

You could read in the file, then use RegEx to find a list of matches:

Code: Select all

ReadFile>c:\bla\somefile.txt,fileData
RegEx>\d{9,10},fileData,0,matches,nm,0
//do we have a match?
If>nm>0
  //first match is in matches_1
  MessageModal>match: %matches_1%
Endif

\d{9,10} means find numeric digits repeated between 9 and 10 times (i.e. find numbers 9 or 10 digits long)

You'll get an array of matches, so if there should be more than one you can loop through the array and do as you please with is.

[doa]

Thank you, Marcus, but I am trying something like this below:

Code: Select all

// script should read somelog.txt and if in it has some number from numbers.txt, show a message
// in numbers.txt are just clean numbers, 9 or 10 digits long, one number per line

ReadFile>c:\log\somelog.txt,file1
ReadFIle>c:\data\numbers.txt,file2


Separate>file1,CRLF,lines


If>lines_count>0
  
  Let>k=0
  Repeat>k
    Let>k=k+1
    
    Let>this_line=lines_%k%
        
    // regex is problem...
    RegEx>%this_line%\d{9,10},file2,0,matches,nm,0
   
    
        If>nm>0
        MessageModal>Found this number, %this_line%       
         
    Endif         
     
  Until>k=lines_count
Endif

I hope you can now see what I need to do.
Thanks again

[Marcus Tettmar]

This shows me that you are reading a file and then you loop through each line, and you use the regex pattern I provided to search each line to see if it contains a 9-10 digit number. If any found it pops the first one in a message box. The code does nothing with the second file.

That's what your code does. But it doesn't tell me what you need to do.

[doa]

Ok, to be more specific, a part of log file is:

9/10/12 3:18PM 03 7654751399 ....
9/20/12 3:21PM 01 624226422 ....
9/10/12 3:21PM 02 7697137935 ....
9/10/12 3:21PM 101 01 514226746 00:00'16" ....
9/10/12 3:21PM 101 02 769713793 00:00'32" ....
9/10/12 3:23PM 03 514239008 ....
9/20/12 3:24PM 01 514226422 ....

Part of second file, numbers.txt

514222312
542235735
7673125253
514256188

And script should read somelog.txt in real time and if in somelog.txt exist some number(s) from numbers.txt, just to show a message with that found number.

What shuld be the right regex for that ? I am confused with that all.
Thank you Marcus and all the best

[doa]

I did it on this way, actually I need only the last line from log file

Code: Select all

ReadFile>c:\log\somelog.txt,data
Separate>data,CRLF,lines
Let>last_line=%lines_count%
ReadLn>c:\log\somelog.txt,%last_line%,last_one

Let>pattern=\d{9,10}
RegEx>pattern,%last_one%,0,matches,num,0

ReadFile>c:\data\numbers.txt,file2

RegEx>(?m)^%matches_1%\d*$,file2,0,matches,nm,0
    
        If>nm>0

               MessageModal>Found it, %matches_1%
       
         
        Endif