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]) |
Thank you for your feedback and comments.We will rectify this as soon as possible!