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 »

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
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: Scanning ' in TM1

Post by PavoGa »

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 »

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