Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASCII comma-delimited import...
Message
From
19/10/1996 21:16:01
 
 
To
18/10/1996 11:11:46
Jim Boho
University of Wisconsin
Madison, California, United States
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00010321
Message ID:
00010583
Views:
37
>>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!!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform