I am trying to put data from excel to csv file. So my excel row contains a string which includes "\n" like "Hello \n Hi \n". If I do convert to csv with Row seperator \n every word is taken as new record in csv file. (Hello and Hi as twodifferent rows) What should I use in this case? Can anyone suggest?
- \n inside text sometime must be preserved in this case you need export text with csv options "" for string and use escape character, many tools understand this
- if you want just remove \n inside text and have straight row - use tMap and replaceAll("\n","") for columns where them presented
Thanks for the reply.
The second point of ur's is not applicable in my case because, I should not change the data.
The first point- Can u elaborate.
this is only one way for save \n inside text and not crash feature import
it is very common for csv export/import and you destination must understand this quotes (for example any database understand this)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables