TM1 Forum

How to find the length of the element in the dimension?

i need a function here? like TI.....
could you please help here its urgent for me.
Thanks for understanding.

Do you mean the number of characters in element's name?

There is a rules/TI function called LEN() that returns the length of a string.

Tried the LONG function?

mincharug.shulft wrote:could you please help here its urgent for me.

... apparently so urgent that there is no time to read the manuals in which you will find the following function:

LONG

This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes.

LONG returns the length of a string.

Syntax
LONG(string)

Example
LONG('Sales') returns 5.

You can find the reference material online here http://publib.boulder.ibm.com/infocente ... m1_ug.html

I think I notice a pattern.
http://www.tm1forum.com/viewtopic.php?f ... 542#p21542

mincharug.shulft wrote:Hello guys this is urgent .could please helps me out on this.

http://www.tm1forum.com/viewtopic.php?f ... 054#p23054

mincharug.shulft wrote:It urgent for me please help me.

http://www.tm1forum.com/viewtopic.php?f ... 094#p23094

mincharug.shulft wrote:could u help me its urgent for me.

http://www.tm1forum.com/viewtopic.php?f ... 992#p26992

mincharug.shulft wrote:kindly let me know if possible its burning for me.

[beaten to it, but why waste all that copying and pasting .... LEN is the Excel equivalent of Long as is MID to SubSt ...]

lotsaram wrote:LEN is the Excel equivalent of Long as is MID to SubSt ...

Duh!