Exploring TM1 - a Chartertech Company
Close this search box.

Scan TM1 Function: How to Use, Syntax and Examples

SCAN, TM1's FIND function

Scan is a TM1 function that finds the numeric position of the first instance of a specified substring within a string. If the substring is not found, it returns zero. It is essentially the same as the FIND command in Excel and CHARINDEX in SQL Server. Syntax of SCAN The syntax is: where substring is the substring you […]

Log In