General information
Category:
Coding, syntax & commands
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only