AnsweredAssumed Answered

GEL Script XOG - Handling Special Characters

Question asked by Christine.Takeuchi on Aug 11, 2013
Latest reply on Aug 20, 2013 by Christine.Takeuchi
One of the data fields in my query occasssionally contains an ampersand and a single quote.

This results set is then used in my GEL Script XOG.

Example #1:
Name = A & R

In my SQL query I currently use to try to present the data in a way that can be used in my XOG script:
SELECT replace(NAME, '&', '&') NAME2
FROM ODF_CA_TABLENAMEX

Resutls returned:
A & R

What is the best way to clean the data and be able to use it for XOG?

Thanks in advance!

Outcomes