Rule Functions

TM1 Function for Rules – INSRT

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.