0x0 - illegal xml character

[Joost Miltenburg]

1 hour ago, comment said:

Tell us something we don't know...

( that could be embarrassing  😋 )

I am not sure what you mean by that.

 

 

Simply put: every time I find a new character that crashes the export. I track it down and add it you my set field ( theField ; substitute( theField ; theChar ; "" ) before running the export.

[comment]

11 hours ago, Joost Miltenburg said:

every time I find a new character that crashes the export.

So how many of those can there be? This is by now a long thread, but I believe they have all been listed, one way or another. Basically, you're talking about all characters between 0 and 31 except 9 (horizontal tab) and 13 (carriage return). I am not too sure about 10 (line feed), and 127 (delete) could be problematic too.

 

-----------------------
ADDED:

I know I just said this is already a long thread, but something is bothering me. I have just now constructed a file where one of the fields contains a NULL character (calculated). I am able to export this as XML, with or without XSLT, with no problems - and I see that the NULL character has been removed, just as I would expect. You say that this character, as well as others, crash your export. Can you provide an exact recipe to reproduce this result?

 

 

Edited August 2, 2017 by comment

[comment]

@Joost Miltenburg

Why won't you answer my question?

 

[Joost Miltenburg]

If I get an error again, I will create an example. I can, quite reliably say, that having the 00x0-character crashes my export. These characters were copy/pasted into fields. Origin: unknown ( but probably Outlook.

In the mean time, I have created a substitute function that strips out characters that came up in this link: http://ascii-table.com/control-chars.php. Haven't had the error, since.

[comment]

The attached file contains the NULL character in record #2, between the words Bravo and Charlie. It was pasted into the field. I am exporting this with no problems.

If it crashes your export, please provide the exact steps to reproduce the problem. 

ExportMe.fmp12

[Joost Miltenburg]

Your example works, which is nice.

When I get an error in my exports, I'll be back.