faking xml-export?

[phonoguy]

folks, we'd like to export xml the simple way from fm. we have a xml-template thats values should be filled with text. completed result xml code will be in one text-field, that will be exported as plain text. no problem, but: special characters have to be converted, otherwise the xml will not work. many of these characters start with "&" and end with ";". is there a conversion-table or routine available that does the replaceing automatically?...or am i on the wrong track?

[cjaeger]

either export with <?xml version="1.0" encoding="mac-roman"> (or iso-8859-1, depending on your operating system) or use the substitute routine. I have posted a calc for exporting as UTF-8 in sample files some time ago.

The only characters you have to manually convert are the &gt; &lt; &amp; &quot; (<>&" ) characters.