CODEW function for IBM Planning Analytics (TM1)

CODEW returns the UTF-8 numeric code for a specified character within a string.

UTF-8 is a character encoding standard that extends ASCII and is widely used in computing, particularly for representing text in every language, emojis, mathematical symbols, and special characters. This universality makes it invaluable for internationalising and localising software and websites.

In the video, CODEW will return the UTF-8 decimal value from a character in the word ‘TM1’.

Where can the CODEW function be used?

Rules and TurboIntegrator

Which TM1 Server version is the CODEW function available for?

Version 11 and 12

What is the syntax for CODEW?

CODEW(String, Location)

String = A text string
Location = A number specifying the character within the string for which you want to convert.

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