>I have a large number of DBF files and I want to find out if any of them contain a certain string.
>
>The Search in Windows Explorer does NOT find it even if I open a dbf file and copy an exact string, then use Search utility to find that string, it still says NOT FOUND
>
>I am not sure what field it will be in, but it will be a 10 digit number, but stored in a character field.
>
>I could open each file and do Control F to find it, but I have several hundred dbf files to look through and numerous strings to look for.
>
>Any suggestions????
How about some variant of
lnNumFiles = ADIR(aDBFS,"*.dbf")
FOR i = 1 TO lnNumFiles
lcStr = FILETOSTR(aDBFS[i,1])
IF myString $ lcStr
ENDIF
ENDFOR
You could also lop off the header portion of lcStr to make sure you are only searching the data section