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.