>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
Perhaps this is a plug for myself, but...
Download my function called Query at download #
31868, and type.
n = Query([Select * from CSV file.csv where not empty(E-mail) into cursor qTemp])
This import the CSV file (file.csv) and filter out any rows without a email address, and produce a cursor (qTemp).
P.S. if you try this and there are any problem, please let me know so I can correct the code.
Greg Reichert