antp.be forum

Hi,

I have a csv file to import. In the plot part sometimes a " occurs. This results, that only the word in the " 's is taken.

e.g. Tired of being referred to by customers as "Excuse me," Rachel interviews for a job as an assistant buyer

Results in

Excuse me

is this due to some csv thing or a bug ?

thx

It could be considered as a bug, yes.
But in CSV the "..." are usually considered as a string delimiter, I guess that the component that I use only keeps what is inside the delimiters what one if found in a field.
In next version this should be solved since I rewrote this part.
Until then, a solution would be to replace all " by “ or '' (two ') or another similar character, and then eventually by script do the opposite change in the catalog (I can provide you such script if needed).

no thanks you dont need to provide me such script.

It occured to me while writing a java application, which writes a csv for importing TV shows. I just changed the application, it uses ' now instead of "