>Has anyone encountered a problem of improper
>importing of ASCII comma-delimited files into
>PROPERLY structured table with APPEND FROM...
>...TYPE DELIMITED??? When the source
>file contains embedded quotation marks or
>apostrophies, the remainder of the string in the source
>file gets imported with the shift to the left (I am not sure
>if I defined it correctly...) Of course I found the way
>around it by writing a conversion program with my
>favorite low-level functions :), but I want to know if there is
>a more efficient sollution.
>
>Appreciate if this at least will start some communication :)
There is a DELIMITED WITH Delimiter option for APPEND FROM that allows use of a character other than quotation marks. I had some data to import into VFP that had quotation marks, so I used ^ as the delimiter. Question mark also worked well for me.
Jim
Previous
Next
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