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

Click here to load this message in the networking platform