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)
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.