We want to wrap the word in a string at new line width character using tmap.
We want to wrap the word in a string at New Line character(\n).Basically, We are pressing ENTER to start a new line.
that is Enter key to create a new line in Our message when pressed.
Input data :
String is captured in comment column.
Comment column given is:
EDI ORDER-SAVE COMMENTS C3 Generic LOC 0833 Expected arrival 01/07/2016 OTYPE NE TRKPC 01 GM/00007643020008361321
Expected data should after transformation:
Long String of Comment field should Splits in 6 different llines
EDI ORDER-SAVE COMMENTS
Expected arrival 01/07/2016
TRKPC 01 GM/00007643020008361321
Exact Output of Data after transformation looks like :
for stockcode entry we dont have comment .But for each Comment entry we don't have stock code on sales order line data.
How to do text wrapping using tmap expression ?
Any help on it would be much appreciated !
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks