TM1 Function for Rule, INSRT

INSRT inserts one string into another string at the given position number.

Available In

Rules and TurboIntegrator

Definition

INSRT inserts one string into another string at the given position number.

Syntax

INSRT(string1, string2, location)

String1  = A text string

String2 = A text string

Location = Character position where we want to insert string1.

Video Demo

Use INSRT function to insert a string into another string and apply it in the rule to populate the Comment measure in the Product Scorecard cube.