Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import CSV with data contain comma
Message
De
30/09/2015 22:55:47
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Import CSV with data contain comma
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
SAMBA Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01625282
Message ID:
01625282
Vues:
51
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform