Talend community forum / How to eliminate new line character in XML file

Vikram · 2012-03-28 08:31:33

Tags: [bug, context, CSV file, database, date, db2, delimited file, deployment, development, error, i18n, java, mssql, mysql, oracle, perl, positional file, PostgreSQL, schema, sybase, tos3.0.0]

i am creating a XML file , based on join of two tables .
Some times there is extra blank space or new line character in DB , how do i treat it ?

EX: Due to the new line character XML file line is

<L1>Jasper
ETL</L1>

Result should be : <L1>Jasper ETL</L1>

pedro · 2012-03-28 08:37:47

Hi

You can use tReplace before XML output component to replace extra blank space with double quotation marks(e.g. "") and replace "\n" with double quotation marks(e.g. "").

Regards,
Pedro

Uploaded Images

janhess · 2012-03-28 10:07:27

You may need to replace \r as well.

Vikram · 2012-03-29 08:58:59

Hi Pedro and Janhess,

Thanks for the suggestions , Appreciate your help !! :)

Tired your solution , it worked :)

Announcement

Unanswered posts

#1 2012-03-28 08:31:33

How to eliminate new line character in XML file

#2 2012-03-28 08:37:47

Re: How to eliminate new line character in XML file

#3 2012-03-28 10:07:27

Re: How to eliminate new line character in XML file

#4 2012-03-29 08:58:59

Re: How to eliminate new line character in XML file

Board footer