TM1 Function for Rules, SUBST

SUBST returns the substring of a specified string. 

Where can the SUBST function be used?

Rules and TurboIntegrator

What is the SUBST function?

SUBST returns the substring of a specified string. 

What is the syntax for SUBST?

SUBST(string, beginning, length)​
​String = A text string​
Beginning = Substring starting position​
Length = Length of the string that we want to repeat

A demonstration on how to use SUBST

Use SUBST function to extracts the substring from a string and apply it in the rule to populate the Comment measure in the Product Scorecard cube.