Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find a record
Message
De
20/01/2009 04:06:31
 
 
À
20/01/2009 00:49:20
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01375362
Message ID:
01375375
Vues:
13
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform