topic XML compact file in Data Quality

XML compact file

Anonymous — Sat, 16 Nov 2024 10:23:32 GMT

I'm using the tAdvancedOutputFileXML to generate an XML file with a compact structure ie all on one line rather than an expanded vertical structure. This works well for the data body, however the version information: <?xml version="1.0" encoding="UTF-16"?> is put on it's own line:
<?xml version="1.0" encoding="UTF-16"?>
<CustomerManagement xmlns:xsi=""><etc etc>
How can configure the component so the CR/LF is removed and everything is on the same line:
<?xml version="1.0" encoding="UTF-16"?><CustomerManagement xmlns:xsi=""> <etc etc>
Any help would be appreciated..

Re: XML compact file

Anonymous — Wed, 14 Sep 2016 11:03:15 GMT

Does anyone have any thoughts?

Re: XML compact file

Anonymous — Wed, 14 Sep 2016 11:32:15 GMT

This seems an odd request, but we developers often get weird requirements I guess. There are two ways to approach this. Since you already have your file created, you might not want to try and recreate the logic in your tAdvanceOutputFileXML and put it in a tXMLMap. If this is the case you can write the file, read it in as a single String using something like tFileInputRaw and then use the code below in a tJavaRow to remove the offending characters....

output_row.content = ((String)input_row.content).replaceAll("\\r|\\n", "");

Alternatively, to do this in one go and then create a file, move the logic into a tXMLMap. Connect that to a tConvertType to convert the output from XML to a String. Then use the logic above. Once that is done, write the newly formatted String to a file.

Re: XML compact file

Anonymous — Wed, 14 Sep 2016 14:31:02 GMT

thanks it's a customer requirement! I'll give it a go..