Use a character function to manipulate character strings in a formula. The input is a column of your dataset, and functions are applied to cell contents.
|
Function |
Syntax |
Description |
|---|---|---|
|
<matchExpr> like <pattern> |
|
Determines whether a character string matches a specified pattern. The search is not case-sensitive. The pattern can include regular characters and the following
special characters:
Note "[", "^",
"-", and "]" are
reserved for future use.
For
example:
"Hiking is fun" like "H% is _un" |
|
Concatenate(str1, str2) |
|
Concatenates two strings into a single string. The operator + can also concatenate strings. For
example:
Concatenate("Mr", "Brown") |
|
Contain(whereStr, whatStr) |
|
Returns occurrences of a string within another string. The search is not case-sensitive. For
example:
Contain("Cats are grey", "aRe") |
|
ExceptFirstWord(str, sep) |
|
Returns a copy of a string, with the first word removed. For
example:
ExceptFirstWord("Level 3, Standford Street", ", ") |
|
ExceptLastWord(str, sep) |
|
Returns a copy of a string, with the last word removed. For
example:
ExceptLastWord("james.brown@company.com", "@") |
|
FirstWord(str, sep) |
|
Returns the first word of a string. For
example:
FirstWord("Senior Developer", " ") |
|
LastWord(str, sep) |
|
Returns the last word of a string. For
example:
LastWord("Red/Purple", "/") |
|
Length(str) |
str: Input string |
Returns the length of a string. For example:
Length("How long") |
|
LowerCase(str) |
str: Input string |
Returns a copy of a string, with all characters converted to lowercase. For example:
LowerCase("GOOD JOB") |
|
Lpad(str, length, pad) |
|
Returns a copy of a string, padded with leading characters to the specified total length. For
example:
Lpad("Incomplete field", 20, "#") |
|
Replace(str, target, replacement) |
|
Returns a string, with all occurrences of a specified string replaced with another specified string. For example:
Replace("hyperthermia", "ert", "ot") |
|
Rpad(str, length, pad) |
|
Returns a copy of a string, padded with trailing characters to the specified total length. For
example:
Rpad("Incomplete field", 20, "#") |
|
SubString(str, start) |
|
Returns a substring of a string. For example:
SubString("Wong", 3) |
|
SubString(str, start, length) |
|
Returns a substring of a string. For example:
SubString("Wong", 2, 2) |
|
ToText(param) |
param: Parameter to convert |
Converts a parameter to a string. All parameters are valid, and numbers are truncated to zero decimal places. |
|
Trim(str, toTrim) |
|
Returns a copy of the string, with the leading and trailing repetitions of a character removed. This function is case-sensitive. For example:
Trim("Aurora", "a") |
|
TrimLeft(str, toTrim) |
|
Returns a copy of the string, with the leading occurrence of a character removed. This function is case-sensitive. For example:
TrimLeft("Above", "A") |
|
TrimRight(str, toTrim) |
|
Returns a copy of a string, with trailing repetitions of a character removed. This function is case-sensitive. For example:
TrimRight("Laura", "a") |
|
UpperCase(str) |
str: Input string |
Returns a copy of a string, with all characters converted to uppercase. For example:
UpperCase("Little Boy") |
|
ToDate(string, format) |
The date format is a combination of the following reserved
tokens, separated by delimiters:
|
Converts an input string in a dataset to a date in a specified format, when the dates in a column of an original data source are in string format. For
example:
ToDate(Obj, 'yyyy/dd/MM') |
|
Name |
Trimmed string |
|---|---|
|
Aurora |
Auror |
|
Auror |
Auror |
|
auror |
uror |
|
aurora |
uror |
|
uror |
uror |