GXS AI: how to process slash in XML data

If you are working with XML in GXS AI and your data contains a slash (like <Date>2016/01/08</Date>), you might face a situation when your map cannot process it, since slash is a special symbol.

Since this question is raised from time to time, I decided to write a short post about it. There are 2 ways (we are speaking about the map development, not about the map working in the production system):

1. you can change your data manually and add a release character in front of your slashes in the data
-or-
2. you can run otxmlcanon.exe pre-processor which would “fix” your XML file and do the same as it described in #1

otxmlcanon.exe -r \ _in.xml

Then, in your source model you should add release character:

SET_FIRST_DELIM(62) ; >
SET_SECOND_DELIM(60) ; <
SET_THIRD_DELIM(47) ; /
SET_FOURTH_DELIM(34) ; "
SET_FIFTH_DELIM(39) ; ,
SET_RELEASE(92) ; \ – this one is important

Gennady Kim