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

Click here to load this message in the networking platform