I have that old exe in the root of my F drive. Early (norton) utilities
were written in assembler and were very zippy.
----- Original Message -----
From: "James Bentley" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, November 10, 2009 3:58 PM
Subject: [RBASE-L] - Re: Searching for file contents
Bob
I ofter use and old Norton utility "TS" text seach. to do what you want.
In place of this you might
consider using the Windows command line utility FINDSTR. This utility
can do a "literal" search or
a "regular expression" search. Try the following
FINDSTR /I /M /C:"your search term" *.* > output.log
The output is a list of filenames you could them import the output.log
file into a temporary table
/I ignores case
/M only list filenames where there is a match
/C: is the literal string you are searching for in " "
*.* may need a path qualifier
output.log could be any file name. You could even use the rbase command
FILENAME(0) to generate a file name for you
You could always create a permanent batch file and pass the search string
and output file name as parameters or you could write out a BAT file each
time.
RBase ZIP command is still involved
Jim Bentley
American Celiac Society
[email protected]
tel: 1-504-737-3293
________________________________
From: "[email protected]" <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tue, November 10, 2009 11:39:43 AM
Subject: [RBASE-L] - Re: Searching for file contents
Thank you to all who replied. I think I need to explain a bit further.
First I am not needing to replace strings, but simply find what files may
contain a string.
We recieve documents via EDI that contain several types of information,
such as Purchase Orders,
Advanced Ship Notices, Invoices, etc. etc.
These documents come in through an AS2 or VAN (ftp) connection and are
processed continously,
24 hours per day. The file names that these documents come in have no
relevance to what they are.
Usually the format is YYYYMMDDxxx.xxx with x being a sequential number.
However, the format
does differ from various sources. So a PO and an Invoice document is not
dicernable by the file name.
On occasion, a user will need to look at the raw data (i.e. the
YYYYMMDDxxx.xxx or whatever file) that a
certain PO, Invoice, ASN etc. came in on. It may be 2 or 3 days later
for example and hundreds of files have been recieved in since.
I want to create a button that a user can enter a PO number, invoice
number etc. and the program do
a search through several hundred files and find the one desired.
Therefore I need to be able to search
the contents of hundreds of files residing in an Archive Folder for a
specific string such as PO number.
Once found, I would then open the specific file automatically for review
by the user.
This could be done by using the Windows Search option and manually opening
the file, but I am
wanting it to be an option within my application. The key here is that a
typical search will be going
through hundreds of files and needs to be a very efficient method.
Hopefully this better explains my requirement.
Thanks,
-Bob
----- Original Message -----
From: "MikeB" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, November 10, 2009 9:17:29 AM GMT -06:00 US/Canada Central
Subject: [RBASE-L] - Re: Searching for file contents
You can set the file as a VarChar and use SLOC to determine if the string
value is in the file.
Set var VFile VarChar = ['TheFullPathNameOfTheFile']
set var vSloc integer = (SLOC(.VFile, 'ST*856*123'))
if vSloc > 0 then
pause 2 using '"ST*856*123" found in current file'
else
pause 2 using 'No Matching String in current file'
endif
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, November 10, 2009 10:03 AM
Subject: [RBASE-L] - Searching for file contents
In Windows you can search for a specific text string in all files for a
folder(s).
DOS has a similar FIND command.
I need to be able to execute this function from within Rbase. Say there
are
100 files
in a folder and I need to find the one that has "ST*856*123" in it.
I can ZIP a FIND command, output the results to a text file, load the text
file into Rbase
and then parse the temp table to see if the string was found.
Any better ideas on how to accomplish this?
Thanks,
-Bob
