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. |