How to eliminate new line character in XML file

One Star

How to eliminate new line character in XML file

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>
One Star

Re: How to eliminate new line character in XML file

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
One Star

Re: How to eliminate new line character in XML file

You may need to replace \r as well.
One Star

Re: How to eliminate new line character in XML file

Hi Pedro and Janhess,
Thanks for the suggestions , Appreciate your help !! Smiley Happy
Tired your solution , it worked Smiley Happy