Functions: text

Below you will find all text-related functions, with a short description and an example model for each of them.

Function / Download Explanation
capitalize Returns the input string with the first character as a capital.
copystring This function copies a specified length of a string.
infinancialwords Returns numbers in written word.
inlegalfinancialwords Returns numbers in written word according to legal rules.
inwords This function returns integers in written word according to legal rules.
length Calculates the length of a piece of text.
lowercase Returns the input in lowercase.
numtostring Returns the input number in the input format.
pos Returns the first index position of a string in the text.
regexmatch Returns whether the the regular expression can be found in the text.
regexallmatches Returns matches of regular expression in text.
replaceregex Replace text that meet the regular expression with a different text.
replacestring Returns a string with another string.
reversepos Returns the last index position of a string in the text.
romannumeral Returns a number as a roman numeral.
template This function composes a phrase or list out of a dataset.
titlecase This function returns a string with all first letters in capitals.
trim This function trims the whitespace of both sides of a string.
uppercase Returns a piece of text in uppercase letters.
uppercasefirst Returns the input string with the first letter in uppercase.