Reference for all text and string operators supported in Noloco formula fields, including &, CONCATENATE, LEFT, RIGHT, MID, LEN, UPPER, LOWER, PROPER, TRIM, CLEAN, FIND, SEARCH, REPLACE, SUBSTITUTE, R
All text and string operators supported in Noloco formulas. Use these for concatenation, substrings, search, case conversion, and formatting.
Available operators: &, CLEAN, CONCATENATE, EXACT, FIND, ISBLANK, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, TEXT, TRIM, UPPER.
text1 & text2
Appends two strings to one another. Alias for CONCATENATE.
Example: "Hello " & "World"
CONCATENATE(text1, text2)
Appends two strings to one another.
CLEAN(text)
Removes non-printable characters from a string.
EXACT(text1, text2)
Checks if two strings are identical.
FIND(searchQuery, text)
Returns the first position a string occurs within another string.
ISBLANK(text)
Returns true if a string is blank.
LEFT(text, numberOfCharacters)
Returns a substring from the beginning of a string.
LEN(text)
Returns the length of a string.
LOWER(text)
Returns a string in lowercase.
MID(text, startPosition, numberOfCharacters)
Returns a substring from the middle of a string.
PROPER(text)
Returns a string with words capitalized.
REPLACE(text, startPosition, replacementLength, replacementText)
Replaces part of a string with another provided string, based on position.
REPT(text, numberOfTimes)
Repeats a string a number of times.
RIGHT(text, numberOfCharacters)
Returns a substring from the end of a string.
SEARCH(searchQuery, text, startPosition)
Returns the first position a string occurs in another string after a start character position.
SUBSTITUTE(text, searchQuery, replacement)
Replaces all occurrences of a provided query with a provided replacement in a string.
Example: SUBSTITUTE(name, "-old", " (discontinued)")
TEXT(number, format)
Converts a number into text according to a specified format.
TRIM(text)
Removes spaces from the beginning and end of a string.
UPPER(text)
Returns a string in uppercase.
Examples — see "Joining text fields" and "Replacing part of a text field"
Last updated
Was this helpful?
Was this helpful?
