Hi All
I'm having a problem with cleaning user inputted text from a HealthCare system my HealthConnect system interfaces with.
The input can be anything posted into an RTF box on an app which stored in oracle, and extracted by HealthConnect from oracle via an XML based API.
When the XML is returned, various values are read out of it using %XML.XPATH.Document and it is the presence certain characters entered into the RTF fields cause XPATH to throw an error. For example,