Unicode Error (0x3) when sorting

[brad2610]

Hello

I have used filemaker Assistant to output a XML page. When I go to sort the table on some of the fields I get an error:

" An invalid XML character (Unicode: 0x3) was found in the element content of the document.

[Martin Brändle]

Was this from a converted database, that was not closed properly sometimes when it still was in FM5 format? This may have come from corruption.

For the fields in question, check all records if they contain some non-printable characters (normally displayed in the database as a square or rectangle), and delete those characters. This might be quite tedious to find out if your database is very large. Another option is to export the records as an XML file - interestingly, FM does not complain although these characters would not be allowed. Load it into a text editor or even a hex editor and search for those characters and try then to find them in the database.

Martin

[brad2610]

Martin

This was from a converted database and from what you are saying this is a data error and not actual xml code. Seems like I have some long work ahead of me.

Thanks for the help. i will give your suggestions a shot.

Brad

[brad2610]

After a long and exhausting process i found the culprit. It was exactly as martin described. Thanks for the help

Brad