Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with append from
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01093036
Message ID:
01093103
Views:
26
Vincent,

How big are these files? Are all the columns character? If so you can probably get away with:
lcContent = filetostr( "theBadFile.txt" )

strtofile( strtran( lcContent, chr(9) + chr(9), chr(9) + [""] + chr(9) ), "theGoodFile.txt" )
Otherwise write a little chunk of code to read the file line by line using fgets() and alines(laData, lcLine, .t., chr(9) ) it into an array, append blank and gather from laData memo

>While that did not produce a syntax error, the result is the same.
>
>I have looked at the text data through a hex editor and I see the correct number of hex 09 values that separates the fields.
>
>Question: Should there be a pair of DOUBLE QUOTES between each of the TAB [CHR(09)] characters when the field is to be empty?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform