TM1 Function for Rules, DELET

​DELET function deletes a specified number of characters from a specified position within a string.

Where can the DELET function be used?

Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the DELET function?

​DELET function deletes a specified number of characters from a specified position within a string.  

What is the syntax for DELET?

DELET (string, start, number)​
String = A text string. ​
Start = Position from where to begin deletion.​
Number = The number of characters to delete. 

A demonstration on how to use DELET

Use DELET function to remove characters from the string and apply it in the rule to populate the Comment measure in the Product Scorecard cube.