Text Functions
Text functions allow you to manipulate and analyze text values.
CONCAT(A, B, ...)
Concatenates multiple values into a single text.
CONCAT( "Hello", name )
CONCAT( "INV", NUM( invoiceNumber, 4 ) )
LENGTH(T)
Returns the length of text T.
LENGTH( name )
LEFT(T, N)
Returns the first N characters from text T.
LEFT( "PO00384", 2 )
RIGHT(T, N)
Returns the last N characters from text T.
RIGHT( "PO00384", 5 )
UPPER(T)
Converts all characters in text T to uppercase.
UPPER( name )
LOWER(T)
Converts all characters in text T to lowercase.
LOWER( name )
CAPITALIZE(T)
Capitalizes the first character of text T.
Other characters are not modified.
CAPITALIZE( surname )
CAPITALIZEFULLY(T)
Capitalizes each word in text T.
Each word starts with an uppercase character followed by lowercase characters.
CAPITALIZEFULLY( fullName )
CHARAT(T, N)
Returns the character at position N in text T.
CHARAT( name, 3 )
SPLIT(T, S)
Splits text T into an array using separator S.
SPLIT( countries, "," )
REGEX(T, R)
Returns the first match of regular expression R in text T.
REGEX( invoiceNumber, "\d+" )
REPLACE(T, A, B)
Replaces all occurrences of A with B in text T.
REPLACE( text, "Dog", "Cat" )
CONTAINS(T, A)
Returns true if text T contains A.
CONTAINS( text, "yes" )
INDEXOF(T, A)
Returns the position of A in text T.
INDEXOF( text, "X" )
SUBSTRING(T, I)
Returns a substring of text T starting at position I.
SUBSTRING( text, 3 )
SUBSTRING(T, I, J)
Returns a substring of text T from position I to position J.
SUBSTRING( text, 3, 6 )