Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find a record
Message
From
20/01/2009 04:06:31
 
 
To
20/01/2009 00:49:20
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01375362
Message ID:
01375375
Views:
11
>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
         *** Found it
     ENDIF
ENDFOR
You could also lop off the header portion of lcStr to make sure you are only searching the data section
Previous
Reply
Map
View

Click here to load this message in the networking platform