Mid (string, start, count [, boolInBytes])

Result Type: Text

Definition: Returns a substring of string starting at start of length count.

Examples:  Mid("Fish and chips", 6, 3)

returns “and”.

If boolInBytes is true or IN_BYTES (which is a constant with value true), then the start and count are regarded as byte offsets, not characters. This option should only be used when the string is known to be pure ASCII. It is much faster because it does not account for multibyte unicode characters.

See Also:

Dice: Get a subcomponent of a delimited tabular string

Head: Get some elements from the start of a delimited string

Left: Get characters from the start of a string

Regex_Match: Test whether a string matches a regular expression

Regex_Replace: Replace text in a string using a regular expression

Replace: Replace matching text in a string with new text

Right: Get characters from the end of a string

Slice: Get a component of a delimited string

Tail: Get some elements from the end of a delimited string

Trim: Remove whitespace from beginning and end of a string