<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

TM1 Function for Rules, TRIM

TRIM removes any leading and trailing spaces from a string.

Where can the TRIM function be used?

Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the TRIM function?

TRIM removes any leading and trailing spaces from a string. 

What is the syntax for TRIM?

TRIM(string)​
String = A text string

A demonstration on how to use TRIM

Use TRIM function to remove any leading and trailing spaces from a string and apply it in the rule to populate the Comment measure in the Product Scorecard cube. ​