Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Low level read-write optimization for very big file
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00733923
Message ID:
00733994
Views:
26
This message has been marked as a message which has helped to the initial question of the thread.
>Step 1: Read one line
>
>Step 2: The second step was the validation of all chars in the string.
> I have the replace every chars < chr(32) by a "?" in the string.
> After this validation, the string was put in an array using ALINES.
> Each rows of the array was tested to determine the type of data (date,datetime,numeric and so on).
> The result was put in another array. If there is 6 "fields" by row, the array have 6 elements.
> For each row read from the file, 1 character was added to each of the array's elements (C for char, T for datetime, etc...).
>
>Step 3: Write the line to a new file
>

Looks like the kind of job for perl or python... not fox.

I've come to love python for this kind of jobs. It's an easy language with powerful string and regex manipulation. Buy a short book on python, read the file manipulation and regex chapter. It's easy to learn and will not duplicate on your vfp skills.

Those languages (python and perl) are string processing champs, indeed.

François
Previous
Reply
Map
View

Click here to load this message in the networking platform