>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement