Remove new line from my source data

[sushantk19]

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.

[TRF · Accepted solution]

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

[sushantk19]

Works perfectly fine!! thanks for your help

[TRF]

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