CLIP(LENGTH[, SUFFIX])
Truncates your string at a certain length. An optional suffix can be given that will only display if the string is truncated. To tack on “…”, specify DOTS for your suffix.
#results in "Boston Common"
{LOCATION.NAME}
#results in "Boston Com"
{LOCATION.NAME.CLIP(10)}
#results in "Boston Com..."
{LOCATION.NAME.CLIP(10,DOTS)}
LOWER
Converts your string to lowercase.
#results in "boston common"
{LOCATION.NAME.LOWER}
NL2BR
Converts any newlines in the string to <br/> tags.
{DATAPOINTS.TEXT_QUESTION_RESPONSE.NL2BR}
SPLIT(DELIMITER,N)
Splits a string on a given delimiter and returns the nth item, as specified.
#results in "Division: East"{DISTRICT.NAME}
#results in "Division "
{DISTRICT.NAME.SPLIT(:,0)}
#results in " East"
{DISTRICT.NAME.SPLIT(:,1)}
STRREPLACE(REPLACEWHAT,REPLACEWITH)
Returns the given string with the REPLACEWHAT parameter replaced with the REPLACEWITH parameter. (Note that neither of these parameters may include commas.)
#results in "Bastan Camman"
{LOCATION.NAME.STRREPLACE(o,a)}
#results in "BostonCommon"
{LOCATION.NAME.STRREPLACE( ,)}
SUBSTR(START[,LENGTH])
Returns a substring with the specified starting point and length. As with PHP’s substr() function, the string starts at position 0 and negative starts and lengths may be given.
#results in "Common"{LOCATION.NAME.SUBSTR(7)}
#results in "Boston"
{LOCATION.NAME.SUBSTR(0,6)}
#results in "Common"
{LOCATION.NAME.SUBSTR(-6)}
#results in "Boston Co"
{LOCATION.NAME.SUBSTR(0, -4)}
TRIM
Trims whitespace from the start and end of your string.
{DATAPOINTS.TEXT_QUESTION_RESPONSE_WITH_WHITESPACE.TRIM}
UPPER
Converts your string to uppercase.
#results in "BOSTON COMMON"
{DATAPOINTS.TEXT_QUESTION_RESPONSE.UPPER}