csv issues on import

Hi Robert
A bug
oh wait it does exist on export yet not in wps or excel visually itself. something wierd going on here

this is what is shown in wps spreadsheets, and excel the same
Pour une photographie conforme à limage de votre entreprise ou de votre événement. Nous réalisons : reportages en entreprise  photographie de studio  Portraits  photos dévénements et de spectacles  photographies dillustrations et également vos mises en page.
Faites appel à un photographe professionnel. LAtelier Image / Yves Carpentier Bruxelles 234234

A carriage return?
Yeah each row has some wierd carriage return in it and messing it up.

I have tried to remove all comma's and " from a csv file. but for some reason it shows " that do not exist in the file.
I made sure i stripped all of them to make sure,
its not wps
nor excel
nor a batch csv test
Does not make any sense that " is shown there when it is non existent in the file itself
unless its a carriage return... seems to be in the text

notepad++ seems to be LF is the issue. 



 

LF SNAPSHOT

omg... line feed \n in the csv files, was messing it up.
something to have in terms of a switch for the textadapter. the little annoying things like that

Hi Brian,

Please take a look to the “advanced option” tab. In some cases, the TextFile Adapter could eliminate this additional line feeds. Perhaps this helps?