String modification
CONCAT
Description: Concatenates two or more strings into a single string.
Syntax: CONCAT ( string_expr1 , string_expr2 [ , ... ] )
Example:
TABLE( CONCAT("T"."First", ' ', "T"."Last") AS "FullName" )
LEFT
Description: Returns a specified number of characters from the left side of a string.
Syntax: LEFT ( string_expr , length )
Example:
TABLE( LEFT("T"."SKU", 3) AS "SKU Prefix" )
LEN
Description: Returns the length of a string in characters.
Syntax: LEN ( string_expr )
Example:
TABLE( LEN("T"."Name") AS "Length" )
LOWER
Description: Converts all characters in a string to lowercase.
Syntax: LOWER ( string_expr )
Example:
TABLE( LOWER("T"."Name") AS "name_lower" )
LTRIM
Description: Removes leading whitespace characters from a string.
Syntax: LTRIM ( string_expr )
Example:
TABLE( LTRIM("T"."Text") AS "NoLeadingSpaces" )
REPLACE
Description: Replaces occurrences of a substring within a string.
Syntax: REPLACE ( string_expr , search , replace )
Example:
TABLE( REPLACE("T"."Text", 'OLD', 'NEW') AS "Replaced" )
REVERSE
Description: Reverses the order of characters in a string.
Syntax: REVERSE ( string_expr )
Example:
TABLE( REVERSE("T"."Code") AS "CodeRev" )
RIGHT
Description: Returns a specified number of characters from the right side of a string.
Syntax: RIGHT ( string_expr , length )
Example:
TABLE( RIGHT("T"."SKU", 2) AS "SKU Suffix" )
RTRIM
Description: Removes trailing whitespace characters from a string.
Syntax: RTRIM ( string_expr )
Example:
TABLE( RTRIM("T"."Text") AS "NoTrailingSpaces" )
SUBSTRING
Description: Extracts a portion of a string starting at a specified position.
Syntax: SUBSTRING ( string_expr , start , length )
Example:
TABLE( SUBSTRING("T"."Text", 2, 5) AS "Sub" )
UPPER
Description: Converts all characters in a string to uppercase.
Syntax: UPPER ( string_expr )
Example:
TABLE( UPPER("T"."Name") AS "NAME" )