Having issues reading XML files with line breaks
Posted: Tue Jul 26, 2016 9:58 pm
Hi All,
I am trying to read the contents of an XML file in to a Text File but encounter error when there is a line break in the XML file.
Job Design
XML Source File -> XML Input Stage -> Transformer -> Text File
The job works fine when there is no line break within the XML fields.
However, when there is a line break in one of the fields I encounter error as follows(I have indicated that the column can have terminators):
XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 226): Invalid character (Unicode: 0x0)
XML Source File structure example:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><TBL_A><FIELD1>513</FIELD1><FIELD2>AAAA
01/BBBB</FIELD2></TBL_A>
Any suggestions on how I could avoid the error but without removing the line breaks ?
I would greatly appreciate your advice.
I am trying to read the contents of an XML file in to a Text File but encounter error when there is a line break in the XML file.
Job Design
XML Source File -> XML Input Stage -> Transformer -> Text File
The job works fine when there is no line break within the XML fields.
However, when there is a line break in one of the fields I encounter error as follows(I have indicated that the column can have terminators):
XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 226): Invalid character (Unicode: 0x0)
XML Source File structure example:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><TBL_A><FIELD1>513</FIELD1><FIELD2>AAAA
01/BBBB</FIELD2></TBL_A>
Any suggestions on how I could avoid the error but without removing the line breaks ?
I would greatly appreciate your advice.