Text Templates

  • Updated

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

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.