Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import CSV with data contain comma
Message
From
30/09/2015 22:55:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Import CSV with data contain comma
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
SAMBA Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01625282
Message ID:
01625282
Views:
52
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.


Any suggestion ?


Thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform