How to eliminate new line character in XML file

[_AnonymousUser]

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>

[Anonymous]

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

[janhess]

You may need to replace \r as well.

[_AnonymousUser]

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