Exploring TM1 - a Chartertech Company
Close this search box.

STR TM1 Function: Syntax and Use

STR is a TM1 function that converts a number to string.

It is very similar to the Excel function “TEXT”, except you don’t need to specify the format of the output.

If you are looking for the command to convert a string into a number, please see the Numbr function.

Syntax of STR

STR (number, length, decimal); where:

  • number – the actual number you want to convert,
  • length – the length of the string output, with padded blank spaces if your number is shorter than the value entered here,
  • decimal – how many decimal places to take the new string to.


vNumber = 166.359

STR ( vNumber , 6 , 1 );

Will return ‘ 166.4’, i.e. six characters long with a leading space.

This function can be used in both TM1 Rules and TurboIntegrator processes. It is also very similar to the NumberToString function, however that can only be used in TI Processes.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In