String Functions

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 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.