Invalid XML Character (Unicode: 0x8)

Question

I’m using the XML Generator snap.  I’ve already stripped out the usual suspect characters (&amp;, &lt;, &gt;, ", ", %) but I am still getting the following error.
Writing document to error view with behavior: continue; reason=An invalid XML character (Unicode: 0x8) was found in the element content of the document.
I’m processing a VERY large file, so that preview function isn’t helping much.  Does anyone have a suggestion on how I can locate and replace the offending unicode character?

robin · Answer

@alex.panganiban.guild, the unicode character 0x8 represents a backspace:  - backspace (u+0008) copy and paste - Unicode® symbol
It shows up within XML Generator’s template editor like so (see the pink highlighted period-like character before “Tove”):

Assuming you have direct access to the XML, the easiest way to remove it is most likely an external text editor. For instance, I can find and replace all occurrences of this character using TextWrangler and regex search:

If you wish to stay within the product, the SnapLogic Expression Language’s replace() String function can be used (although note that the backspace character will be invisible in the UI components within Mapper etc.):

alex_panganiban · Answer

thank you, i’ll try this out. appreciate the assist!

Forum Discussion

Invalid XML Character (Unicode: 0x8)

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?