Formula Explanation Example Formula Example Explanation
concat() Combine multiple strings into one. concat("Hello", " ", "World") Combines 'Hello' and 'World' into 'Hello World'.
length() Return the length of a string. length("Hello") Returns the length of 'Hello', which is 5.
slice() Extracts a substring from a string based on start and end index. slice("Hello", 1, 4) Extracts 'ell' from 'Hello'.
contains() Checks if a string contains a specified substring. contains("Hello", "ell") Returns true because 'Hello' contains 'ell'.
startsWith() Checks if a string starts with a specific substring. startsWith("Hello", "He") Returns true because 'Hello' starts with 'He'.
endsWith() Checks if a string ends with a specific substring. endsWith("Hello", "lo") Returns true because 'Hello' ends with 'lo'.
format() Formats a value as a string according to a specified pattern. format(1234, "0,0.00") Formats 1234 as '1,234.00'.
join() Merges elements of an array into a string separated by the specified separator. join(["Hello", "World"], " ") Joins 'Hello' and 'World' with a space resulting in 'Hello World'.