String variable with ' character

Post Reply
xRobChandler
Posts: 11
Joined: Wed Aug 07, 2013 6:47 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010 32 bit

String variable with ' character

Post by xRobChandler »

Hi all,
I have a TI process that checks the values in a string variable thus:
IF( DETAILED_COURSE_LEVEL @= 'BACHELOR'S PASS' ) ;
My problem is that the test value also has the ' character as part of the string. How do to I escape that second ' within the test string?

Thank you very much...
Rob :oops:
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: String variable with ' character

Post by qml »

This has been discussed before.
Kamil Arendt
xRobChandler
Posts: 11
Joined: Wed Aug 07, 2013 6:47 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010 32 bit

Re: String variable with ' character

Post by xRobChandler »

Aah! Thank you.
Post Reply