Handling ampersand chacrater in data XML


Is there a way to load data with ampersand charcater in it.

We have clinets with ampersand as part of the client name field.

The grid.loadXML(“file.XML”) method failes with the following message:

Error type: LoadXML

Description: Incorrect XML

When ampersand is removed the file loads fine.

If this character needs to be escaped what is the correct escape syntax?

Thank you!


The XML which you load must have valid syntax.
By XML rules the & char is depricated, it must be replaced with

& => &

Also please beware that HTML based column types ( all except rotxt and edtxt ) will threat ampersand by HTML rules, so you may need to do double escaping

& =>&