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: 
sushantk19
Creator
Creator

Remove new line from my source data

Hi All,

 

I am receiving new lines between my text data for one of the source fields. The data in comments field is coming as as eg:

 

Input data

===========

There is a
newline space in this column

 

Output data expected

================

There is a newline space in this column.

 

Please note, source is not a flat file but a relational source. I have created a simple job design

Source DB===>tLogRow=>tFileOutputdelimited.

 

How to resolve this issue. I am new to Talend.

 

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Use the following expression in a tMap or tJavaRow to eliminate every \n from your input:
row1.inputField.replaceAll("\\n", " ")

View solution in original post

3 Replies
TRF
Champion II
Champion II

Use the following expression in a tMap or tJavaRow to eliminate every \n from your input:
row1.inputField.replaceAll("\\n", " ")
sushantk19
Creator
Creator
Author

Works perfectly fine!! thanks for your help 0683p000009MACn.png

TRF
Champion II
Champion II

Great, don't forget to mark your case as solved