Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gt0731
Contributor III
Contributor III

How do I wrap words in a String at new line character using tmap?

Hi ,
Greetings,
We want to wrap the word in a string at new line width character using tmap.
that is
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
C3 Generic
LOC 0833
Expected arrival 01/07/2016
OTYPE NE
TRKPC 01 GM/00007643020008361321


Exact Output of Data after transformation looks like :
http://paste.ofcode.org/KbgzFqYqUUaSGpTQFgarWh

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 !

Labels (2)
0 Replies