TM1 Forum

Hi All,

I have came to issue where i need to scan for ' (Single quotes). the issue was i am capturing user names in the TM1 from cognos and i have one user Name "N'DOUBA". Now the issue is i am exporting this to database with SQL statement and because of this special character TI getting failed.
Also i am not find way to scan this special character and use alias if we found this.
Kindly help me with solution on this.

Thanks,
Vaibhav

Try storing the ASCII character for that in a variable and then SCAN for the variable.

Hi Thanks for the update, I got workaround to scan this by using CHAR(39) code