Mid

Description

Obtains a specified number of characters from a specified position in a string.

Syntax

Mid ( string, start {, length } )

Argument

Description

string

The string from which you want characters returned.

start

A long specifying the position of the first character you want returned (the position of the first character of the string is 1).

length (optional)

A long whose value is the number of characters you want returned. If you do not enter length or if length is greater than the number of characters to the right of start, Mid returns the remaining characters in the string.

Returns

String. Returns characters specified in length of string starting at character start. If start is greater than the number of characters in string, the Mid function returns the empty string (“”). If length is greater than the number of characters remaining after the start character, Mid returns the remaining characters. The return string is not filled with spaces to make it the specified length.

Examples

Example 1

This expression returns “”:

Mid("BABE RUTH", 40, 5)

Example 2

This expression returns BE RUTH:

Mid("BABE RUTH", 3)

Example 3

This expression in a computed field returns ACCESS DENIED if the fourth character in the column password is not R:

If(Mid(password, 4, 1) = "R", "ENTER", "ACCESS DENIED")

Example 4

To pass this validation rule, the fourth character in the column password must be 6:

Mid(password, 4, 1) = "6"

See also