You are not logged in.
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>
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. "").