ETL and Data Integration tools - Modern ETL software for everyone

Hi,
I am trying to Import a carriage return line feed using the visual importer enterprise.
The carriage return character shows up in the csv file as a square, the importer however sees it as a row rather than a line break in the same cell. Is this possible?

"002.0","TYPHOID FEVER
TYPHOID (FEVER) (INFECTION) [ANY SITE]","A002","2006-01-01 00:00:00",""

It looks like above, but with a carriage return character after “FEVER.”
Tim

I think it should work in you specify correct line terminator

See the screenshot attached

Mike