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
Scanning ' in TM1
-
- 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:
- PavoGa
- MVP
- Posts: 618
- 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
Try storing the ASCII character for that in a variable and then SCAN for the variable.
Ty
Cleveland, TN
Cleveland, TN
-
- 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
Hi Thanks for the update, I got workaround to scan this by using CHAR(39) code