General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only