topic Re: Remove new line from my source data in Talend Studio

Remove new line from my source data

sushantk19 — Sat, 16 Nov 2024 02:49:41 GMT

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 — Tue, 31 Mar 2020 14:46:36 GMT

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

sushantk19 — Tue, 31 Mar 2020 15:07:17 GMT

Works perfectly fine!! thanks for your help

TRF — Tue, 31 Mar 2020 15:08:26 GMT

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