String Functions

The StringFormulaLibrary class provides various string manipulation functions.

Functions

ISEMPTY

• Description: Checks if a string is empty.
• Parameters: 1 (String)
• Usage: ISEMPTY(string)

ISBLANK

• Description: Checks if a string is blank (null or empty).
• Parameters: 1 (String)
• Usage: ISBLANK(string)

TOUPPERCASE

• Description: Converts a string to uppercase.
• Parameters: 1 (String)
• Usage: TOUPPERCASE(string)

TOLOWERCASE

• Description: Converts a string to lowercase.
• Parameters: 1 (String)
• Usage: TOLOWERCASE(string)

STARTSWITH

• Description: Checks if a string starts with a specified prefix.
• Parameters: 2 (String, String)
• Usage: STARTSWITH(string, prefix)

ENDSWITH

• Description: Checks if a string ends with a specified suffix.
• Parameters: 2 (String, String)
• Usage: ENDSWITH(string, suffix)

CONTAINS

• Description: Checks if a string contains a specified substring.
• Parameters: 2 (String, String)
• Usage: CONTAINS(string, substring)

SUBSTRING

• Description: Extracts a substring from a string.
• Parameters: 3 (String, Number, Number)
• Usage: SUBSTRING(string, start, length)

TOSTRING

• Description: Converts a value to a string.
• Parameters: 1 (Any)
• Usage: TOSTRING(value)