Text templates are used to lookup or modify text values.
Template name | Template format | Return type |
matches regular expression | <text> matches regular expression <regex pattern> |
Boolean |
matches wild card expression |
<text> matches regular expression <wild card pattern> |
Boolean |
with no leading or trailing spaces |
<text> with no leading or trailing spaces |
text |
with whitespace removed | <text> with whitespace removed |
text |
contains whitespace | <text> contains whitespace |
Boolean |
contains | <text> contains <text> | Boolean |
starts with | <text> starts with <text> | Boolean |
ends with | <text> ends with <text> | text |
the left | the left <number> of characters in <text> |
text |
the right | the right <number> of characters in <text> |
text |
the middle | the middle <number> of characters in <text> starting with character <number> |
text |
length of | the length of <text> | text |
formatted as currency | <number> formatted as currency |
text |
formatted as hexadecimal | <number> formatted as Hexadecimal |
text |
formatted as number | <number> formatted as number |
text |
formatted as percent | <number> formatted as percent |
text |
formatted as scientific | <number> formatted as scientific |
text |
combine | combine <value> with <value> |
text |
concatenate | concatenate <values> or use the & operator: <text> & <text> |
text |
format | format <date> as <format> (Note: templates for <format> are long date, long datetime, long time, short date, short datetime, short time, yearmonth) |
text |
get position of | get position of <search text> in <target text> |
number |
replace | replace <old text> in <text> with <new text> |
text |
replace pattern | replace <regex pattern> in <text> with <text> |
text |
select text from | select text from <text> which matches regular expression <regex pattern> |
text |
with invalid JSON characters escaped |
<text> with invalid JSON characters escaped |
text |
Comments
0 comments
Please sign in to leave a comment.