Text markup functions
Markup functions are used for creating marked up text (hypertext) from string values and/or other marked up text.
Usage notes
There are the following features of using markup:
- These functions return
NULL
when any argument isNULL
. To get a non-NULL value, wrap argumens inIFNULL()
. Example:bold(ifnull([value], 'NULL'))
. - Converting markup to a normal string is not currently possible.
- Markup functions can be used within logic functions. Example:
IF(STARTSWITH([value], 'n'), BOLD([value]), MARKUP([value]))
.
BOLD
Syntax:BOLD( text )
Stylizes the passed text in bold font.
ITALIC
Syntax:ITALIC( text )
Stylizes the passed text in cursive font.
MARKUP
Syntax:MARKUP( arg_1, arg_2, arg_3 [ , ... ] )
Merges marked up text pieces. Can also be used for converting strings to marked up text.
URL
Syntax:URL( address, text )
Wraps text
into a hyperlink to URL address
.