Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import from a CSV
Message
De
31/01/2007 08:54:04
Suhas Hegde
Dental Surgeon
Sirsi, Inde
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01190812
Message ID:
01190821
Vues:
11
>I am importing from a .csv to a table
>
>notice the line break afer the 17471 product
>
>Núm,Feito em,Nome,E-mail,Empresa,CPF/CNPJ,RG/IE,
>"17435","24/01/2007 15:09:00","Anoar José Dartora",
>"17471","29/01/2007 13:36:00","ARIOVALDO A. CAPIRAZI"
>",,,,,,,,,,0,431465,"0.00",
>"17472","29/01/2007 15:01:00","Lázaro Moreira Sales",
>
>What is the best way to import it, in order to skip this line break ?
>
>I am using append from but I have to manually treat the .csv
>
>Moises


some thing like

create cursor test (Num i,Feito T,Nome C(30),Email c(50),Empresa c(30),CPF_CNPJ c(30),RG_IE c(30))

append from mycsvfile for !empty(feito) type csv
brow

suhashegde
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform