Text Templates

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 righ t	the right <number> of characters in <text>	text
t he 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 hexadecima l	<number> formatted as Hexadecimal	text
formatted as number	<number> formatted as number	text
formatted as percen t	<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
r eplace 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