Scan function for IBM Planning Analytics (TM1)

Where can the Scan function be used?

Which TM1 Server version is the Scan function available for?

What is the syntax for Fill?

• ​Substring = A text string​
• String = A text string 

Relevant Functions

• CapIt = capitalises the first letter of every word in a string
• Char = Converts the ASCII numeric code into the character
• Code = Converts the character to the ASCII numeric code
• CodeW = Returns the UTF-8 numeric code for a specified character within a string
• Delet = Deletes a specified number of characters from a specified position within a string
• Fill = Repeats a string to the specified number of lengths
• Insrt = Inserts one string into another string at the given position number
• Long = Returns the length of the string
• Lower = converts text characters to lowercase
• Numbr = Converts string character to a number
• Scan = Searches the specified substring within a string and returns the starting position of the substring
• Str = Converts number to a string character
• SubSt = Returns the substring of a specified string
• Trim = Removes any leading and trailing spaces from a string
• Upper = Converts text characters to upper case