Clarity: How to Remove Special Characters from .xml files used with XOG

Document ID : KB000049307
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

At several occasions while using Clarity XML Open Gateway (XOG) action between environments, you may face an issue of XOG returning an error because of special characters inside the read or write XML file being used. How do we find all the special characters that will cause this problem?

Solution:

Use the following steps to modify the xml file with the issue:

  1. Make a copy of your XML file in case you need to start over

  2. Open the xml file in any Text editor supporting Regular Expression Find/Replace feature

  3. Open the Find/Replace edit window

  4. Select the Regular Expression option

  5. Find : [^&;:()a-zA-Z0-9" =./><_-~-]

  6. Replace with non special characters

  7. Save the file and perform the XOG action again

Keywords: CLARITYKB, how-to, configuration.