Create valid XML function

[Pete56]

Crystal 10
Various datasources
Task: Create a report that is an XML file
Function sample: 'pat_fname="'+trim(replace({icacs.cs_fnam},"&","and"))+'"'
This will put the cs_fnam field in the file preceded with the tag name and surrounded by quotees with the & characters changed to and

Problem: I would like to create a function that would take a text field as input and do everything to the field that needs to be done to make sure it does not have any special characters or anything else that will cause the file not to be a well formed XML file.

Does something like this already exist?
Does someone have a list of the checks that need to be made?

thanks.

Pete

 

[Pete56]

Related Question:

Is there a way to set Crystal to change the value of special characters in a text field to the &value. For example, all " to &quot? This would solve most of the issues with the XML request above.

Thanks.

Pete