Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Suggestions to extract from large .txt file?
Message
De
15/09/2017 11:52:22
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01654358
Message ID:
01654361
Vues:
58
>>>Hi,
>>>
>>>Since APPEND FROM does not work with MEMO field, I need to extract data from several .TXT files using an alternative approach. I thought of parsing the file with VFP code, loading the file into a string with FILETOSTR(). But the string is too long (the .txt file is about 6 MB).
>>>I would appreciate any suggestions?
>>
>>Dmitry, I would say that 6MB is a piece of cake for VFP.
>>
>>Do your .TXT files have a first-line header?
>
>Yes, the .TXT file top line identifies the columns in the .TXT file. Are you saying that FILETOSTR() should load the entire file?

FILETOSTR() can load the entire file easily. I think I put a function to read a file with headers here at LevelExtreme, recently... and probably just one among many...
----------------------------------
António Tavares Lopes
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform