Scanning ' in TM1

Post Reply
late.vaibhav
Posts: 25
Joined: Mon Dec 09, 2013 1:00 pm
OLAP Product: tm1
Version: 9.5.2, 10.2.2
Excel Version: 2007 2010
Location: India
Contact:

Scanning ' in TM1

Post by late.vaibhav » Fri Jun 22, 2018 10:34 am

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

User avatar
PavoGa
Community Contributor
Posts: 227
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0
Excel Version: 2013
Location: Cleveland, Tennessee

Re: Scanning ' in TM1

Post by PavoGa » Fri Jun 22, 2018 11:57 am

Try storing the ASCII character for that in a variable and then SCAN for the variable.
Ty
Cleveland, TN

late.vaibhav
Posts: 25
Joined: Mon Dec 09, 2013 1:00 pm
OLAP Product: tm1
Version: 9.5.2, 10.2.2
Excel Version: 2007 2010
Location: India
Contact:

Re: Scanning ' in TM1

Post by late.vaibhav » Fri Jun 22, 2018 3:37 pm

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

Post Reply