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

That does not resolve the problem! If you have a choice of
formats to create, - of course you would choose the easiest
to work with! I normally choose ASCII TAB DELIMITED!
But what if the COMMA DELIMITED is the only one
available????? I have to deal with data that came from
a rigidly written exporting routine that does not create
anything else BUT ASCII COMMA DELIMITED!!!
(BTW, the question was:

... I want to know if there is a more efficient sollution.

...But thanks for reply anyway :)
Some things are better be left unknown...NOT!!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform