About string functions

String functions perform various actions that modify the characters returned for a string of characters. While string functions can be used to create metrics, a more common use case for these functions is in the creation of attribute forms. For example, these functions can aid in the creation of attribute forms by combining multiple columns of information, capitalizing the first letter of a column, removing or returning select characters of a column, and so on. For information on creating attributes and attribute forms, see the Project Design Help.

The following topics include details on how to use the various string functions:

• Concatenate

• Concatenate with a Blank

• Initial Cap

• Left String (string from input's left)

• Left Trim

• Length

• Lower Case

• Position of first occurrence

• Right String (string from the input's right)

• Right Trim

• Substring

• Trim

• Upper Case

For additional information on String functions, refer to the MicroStrategy Functions Reference.