Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suggestions to extract from large .txt file?
Message
From
15/09/2017 11:52:22
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01654358
Message ID:
01654361
Views:
57
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform