Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import CSV with data contain comma
Message
From
01/10/2015 00:49:01
 
 
To
30/09/2015 22:55:47
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
SAMBA Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01625282
Message ID:
01625284
Views:
45
>g'day
>
>Because I like to retain 1st row of csv file, I using the common
>
>APPEND FROM (mGetFile) TYPE DELIMITED WITH ","
>
>rather then
>
>APPEND FROM (mGetFile) TYPE CSV
>
>But with this method if data column contain common, VFP will slit the data into 2 column,
>
>eg
>cusno,itemNo,model,qty
>LD50,18340,LD90T0RELK,100
>LD80,18340,"LD80,T0RELK",200
>
>the 3th row of data will have 1 extra column.
APPEND FROM (mGetFile)  TYPE DELIMITED
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform