Concatenate

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

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.
3. The string you want to substitute.

Example

Ex. Replace("example", 2, 3, "*") – returns e*ple.

Right

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.

String Functions