Subject:separate one record to two lines by special character 0C Author:Fairy Lee Date:10 Feb 2009 12:57 PM
I have some records that are separated into two lines, so the first line is ended by 0C and the second line is ended by 0D 0A. It reports the following error when converting this ASCII file into XML:
"Can't encode 0xc in text"
What can I do for this issue?
Subject:separate one record to two lines by special character 0C Author:Minollo I. Date:10 Feb 2009 03:03 PM
0xC is not a valid character for an XML document (http://www.w3.org/TR/REC-xml/#charsets); if your XML document contains a 0xC character, then that's not a well-formed XML document, and an XML parser will not be able to parse it. You will need to filter out that character before it reaches the XML parser.
Subject:separate one record to two lines by special character 0C Author:Tony Lavinio Date:11 Feb 2009 11:02 AM
If you're using Custom XML Converters, either try adding it to
the "Toss Characters" property as '\f' or adding it to the "Left
Padding" or "Right Padding" properties, if it is inside some
delimiters.