mid

Extracts a substring from a string.

mid(String, start, count) → returns String

Argument Reference for the mid function

String

Required: Yes
The string from which the substring will be extracted.

start

Required: Yes
The position of the first character to retrieve.

count

Required: Yes
The number of characters to retrieve.

Examples sample code invoking the mid function


Extract month from date

Grabs the month out of a raw date yyyymmdd value.

mid("20001122", "5", "2")

Expected Result: 11


Fork me on GitHub