Illegal characters in XML export
We run SAP Business One 2007 PL37.
On the Item Master Data, our product manager inserts descriptions on our products under Remarks (OITM.UserText).
This information is gathered from supplier's websites and is inserted with copy/paste.
However, we regularly export our data back and forth between several systems and some of the characters that have been pasted in turn out as invalid XML characters even though they are accepted into SAP through the client.
Is there any way to "clean" these characters from OITM.UserText?