Single Quote in Element Name

[PlanningDev]

Is there a way in a rule to reference an element that has a single quote (apostrophe) in the name?

[Martin Ryan]

I think there is an escape character, but I can't think of it. The other alternative is to create an alias and reference the alias in the rule instead.

Martin

[ccierpik]

You could joining text strings and using Char(39), for example 'SomeText' | Char(39) | 's String'

[Gregor Koch]

Hi
Try putting another single quote in front of the single quote that is part of your element name.

Element Name: Blah'Blah

Rule: ['Blah''Blah']=N:1;

Cheers

Edit: Forgot the ending single quote, sorry.

[lotsaram]

... goes without saying but always a very bad idea to have any kind of reserved characters in any TM1 object or element names. Especially ones that interfere with writing rules or MDX.

[Wim Gielis]

True, Lotsaram.

See: http://users.skynet.be/fa436118/wim/tm1singlequote.htm