Exago Logo
Search
Generic filters
Exact matches only

String Functions

String functions are commonly used for interpreting and manipulating text fields.

Concatenate

Description Joins several text strings into one text string.
Remark The “&” operator can be used instead of Concatenate() to join strings
Example Concatenate("This ","is ","one ","string!") – returns This is one string!
"This " & "is " & "another " & "string!" – returns This is another string!

JSONExtract v2021.2+

The JSONExtract function is documented in its own article.

Left

Description Returns the first character(s) of a text string.
Remark The first argument is the string you want to display. The second argument is number of characters you want.
Example Ex. Left(“example”, 2 ) – returns ex.

Len

Description Returns the number of characters in a text string.
Example Ex. Len(“example” ) – returns 7.

Lower

Description Converts all uppercase letters in a text string to lowercase.
Example Ex. Lower(“EXAMPLE” ) – returns example.

Mid

Description Returns a specific number of characters from a text string starting where you specify.
Remark Mid takes three input arguments:
1. The text string.2. The place you want to start.3. The number of characters you want to display.
Example Ex. Mid(“example” , 2, 3) – returns xam.

NewLine

Description Begins a new line of text.
Remark NewLine takes no arguments.
Example Ex. NewLine()

Replace

Description Replaces part of a text string.
Remark Replace takes four input arguments:
1. The text string to partially replaced.
2. The place you want to start replacing.
3. The number of characters to replace.
4. The string you want to substitute.
Example Ex. Replace(“example”, 2, 3, “*”) – returns e*ple.
Description Returns the last characters in a text string.
Remark The first argument is the string you want to display. The second argument is number of characters you want.
Example Ex. Right(“example”, 2) – returns le.

Trim

Description Removes all spaces from text except for single spaces between words.
Example Ex. Trim(“This     sentence     has   weird    spacing.”, 2) – returns This sentence has weird spacing.

Upper

Description Converts text to uppercase.
Example Ex. Upper(“example”) – returns EXAMPLE.

Value

Description Converts a text string that represents a number to a number.
Example Ex. Value(“$1,000”) – returns 1000.
Was this article helpful?
4.5 out of 5 stars
5 Stars 0%
4 Stars 100%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents