You are not logged in.
Hi Pedro and Janhess,
Thanks for the suggestions , Appreciate your help !! :)
Tired your solution , it worked :)
You may need to replace \r as well.
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. "").
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
Result should be : <L1>Jasper ETL</L1>