Strings: All You Can Eat!

31 min total time

17 articles

3 authors

Start Reading

Playlist

Strings: All You Can Eat!

All about strings. Whether you’re a cat chasing a ball of string, or a TM1 admin manipulating strings to push them out to an ASCII file, concatenating them, or sending them to a text-based attribute, here is your complete guide to all things to do with strings in TM1.

17 posts - 3 authors

Rule Functions | TI Functions

RIGHT TM1 Function: Use and Syntax

If you are looking for the RIGHT function in TM1, you'll find that it doesn't actually exist!...

Rule Functions | TI Functions

LONG TM1 Function: Syntax and Use

The LONG function in TM1 returns the length of a string as a value. It is similar to the LEN...

Rule Functions | TI Functions

LEFT TM1 Function: Use and Syntax

The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you have a...

Rule Functions | TI Functions

SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): How to Use and Syntax

The SUBST function is essentially the same as the Excel MID function or the SQL Server...

SCAN, TM1's FIND function

SCAN, TM1's FIND function

Rule Functions | TI Functions

Scan TM1 Function: How to Use, Syntax and Examples

Scan is a TM1 function that finds the numeric position of the first instance of a specified...

Rule Functions | TI Functions

Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is...

Rule Functions | TI Functions

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...

CellGetS TM1 Function: How to Use and Syntax

CellGetS allows you to retrieve a string (text value) from a specific intersection in a TM1 cube...

Rule Functions | TI Functions

DType Function in TM1: Syntax and Use

Use, syntax and example of the DType function in TM1 and Planning Analytics. In this post we...

NumberToString TM1 Function: How to Use and Syntax

NumberToString Function for use in Turbo Integrator processes in TM1 and Planning Analytics to...

StringToNumber TM1 Process: Use and Syntax

StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator...

Attributes String

Attributes String

Attributes | Rule Functions | TI Functions

ATTRS TM1 Function: How to Use and Syntax within TI and Rules

ATTRS Function for use in Rules and Turbo Integrator Processes in TM1 and Planning Analytics to...

Integration | TI Functions

Text File Export from TM1 – AsciiOutput Functions

When we are exporting from TM1 to a text file there is a set of functions we can set that modify...

Integration | TI Best Practices

AsciiOutput with Pipe Delimiter

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect...

Header Row from AsciiOutput

Header Row from AsciiOutput

Integration | TI Best Practices | TI Data Sources | TI Functions

How to Create a Header Row with AsciiOutput

Here is a great explanation of how to add a row of column headings to an AsciiOutput from TM1....

Fixed Width File Format from TM1

When outputting data from TM1 usually we can get away with comma separated values format. Which...

Guest Post: Sorting TM1 Text Output – Wim Gielis

First of all, thanks to Ben for inviting me to write this guest article. The case is as follows....