Configure String expression
Functions
LEN
| Syntax | LEN(string_expression) |
| Description | Returns the number of characters in the given string expression. |
| Example | LEN([ShipPostalCode]) |
CHAR
| Syntax | CHAR(integer_expression) |
| Description | Converts the given integer ASCII code into a character. |
| Example | CHAR(70) |
CONCAT
| Syntax | CONCAT(string_expression1, string_expression2,…, string_expressionN) |
| Description | Returns a string value resulting from the concatenation of two or more string values. |
| Example | CONCAT('https://en.wikipedia.org/wiki/Main_Page', [ShipCity]) |
CONTAINS
| Syntax | CONTAINS(string_expression, substring_expression) |
| Description | Returns true if the given string expression contains the specified substring expression. |
| Example | CONTAINS([Shipping Address], [ShipCountry]) |
ENDSWITH
| Syntax | ENDSWITH(string_expression, substring_expression) |
| Description | Returns true if the given string expression ends with the specified substring expression. |
| Example | ENDSWITH([CustomerID], 'A') |
INITCAP
| Syntax | INITCAP(string_expression) |
| Description | Converts the first character in each word to uppercase and the remaining characters to lowercase. |
| Example | INITCAP([ProductName]) |
LEFT
| Syntax | LEFT(string_expression, numeric_expression) |
| Description | Returns the specified number of characters from the start of the given string expression. |
| Example | LEFT([ShipAddress], 6) |
LOWER
| Syntax | LOWER(string_expression) |
| Description | Returns a lower case converted string value from a given string expression. |
| Example | LOWER([ShipCountry]) |
LTRIM
| Syntax | LTRIM(string_expression) |
| Description | Returns the string value with any leading blanks from string expression. |
| Example | LTRIM('Removes trailing spaces.') |
MAX
| Syntax | MAX(expression) |
| Description | Returns the maximum value in the given expression. |
| Example | MAX([ProductName]) |
MIN
| Syntax | MIN(expression) |
| Description | Returns the minimum value in the given expression. |
| Example | MIN([ProductName]) |
REPLACE
| Syntax | REPLACE(string_expression, substring, new_substring) |
| Description | Replaces all occurrences of the substring within the given string expression, with the new_substring. |
| Example | REPLACE([ShipCountry],'France','India') |
RIGHT
| Syntax | RIGHT(string_expression, numeric_expression) |
| Description | Returns the specified number of characters from the end of the given string expression. |
| Example | RIGHT([ProductName], 6) |
RTRIM
| Syntax | RTRIM(string_expression) |
| Description | Returns the string value with any trailing blanks removed from a string expression. |
| Example | RTRIM('Remove trailing spaces.') |
STARTSWITH
| Syntax | STARTSWITH(string_expression, substring_expression) |
| Description | Returns true if the given string expression starts with the specified substring expression. |
| Example | STARTSWITH([CustomerID], 'A') |
SUBSTR
| Syntax | SUBSTR(string_expression, starting_index, length_of_the_string) |
| Description | Returns a specific length of a string starting from a specific index from the given string expression. |
| Example | SUBSTR([CustomerID],1,3) - For example, to truncate 'user' from 'user@gmail.com' give value from 0 to 3. |
TRIM
| Syntax | TRIM(string_expression) |
| Description | Removes the leading and trailing spaces from the string expression. |
| Example | TRIM('Remove trailing spaces.') |
UPPER
| Syntax | UPPER(string_expression) |
| Description | Returns an upper case converted string value from a given string expression. |
| Example | UPPER([ShipCountry]) |