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!

The JSONExtract function is JSONExtract Function.

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.

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

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

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.

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.

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.

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

Description	Converts a text string that represents a number to a number.
Example	Ex. Value(“$1,000”) – returns 1000.