Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ASCII comma-delimited import...
Message
De
18/10/1996 11:11:46
Jim Boho
University of Wisconsin
Madison, Californie, États-Unis
 
 
À
17/10/1996 11:09:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00010321
Message ID:
00010433
Vues:
38
>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
Fil
Voir

Click here to load this message in the networking platform