UCMDB and UD Practitioners Forum (Previously CMS)

How to deal with escape character is xslt file

Gregory Pappas
Respected Contributor.

How to deal with escape character is xslt file

We are running UCMDB 8.02 and Service Manager 7.11

I have a xslt file for replicating UCMDB SQL database CITs to Service Manager.
The name of the SQL database in UCMDB includes a slash '\' which is an escape character.
I am attempting to exclude from the SQL database SID everything after and including the slash '\'. [Example: hmch3434\sqlexpress]
Here is the code in the xslt file.

The "otherwise" portion of the file works fine.
What I get in the "when" portion is just "mssql_".
I have tried multiple variations to deal with the escape character '\' being in the name:
substring-before(., ''\'')
substring-before(., '"\"')
substring-before(., '\\')
None of these produce the desired result. In fact most produce errors.

How do I deal with trying to eliminate the text in the SQL database name inside the xslt file?




P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum MOderator