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
Import problem with "
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).
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).
-
deathbyaclown
- Posts: 17
- Joined: 2005-10-12 10:31:11