Syntax

MID(some-text, begin-at, how-many)

Arguments

  • some-text (any textual)
  • begin-at (any numeric or textual) : The position, numbered from 1, of the first character in some-text to return. A real number will be rounded to the nearest integer. A textual value is equivalent to 0. begin-at must be greater than 0.
  • how-many (any numeric or textual) : The number of characters from some-text to return. A real number will be rounded to the nearest integer. A textual value is equivalent to 0. how-many must not be negative.

Return Value

Text: The how-many characters beginning at position begin-at from some-text. If how-many is greater than the remaining length of some-text, the remainder of some-text is returned.

Examples

MID("123 Maple Dr", 5, 5) : Maple

MID("123 Maple Dr", 5, 0) returns blank.

Fractional Component of Decimal Value

NUMBER(MID(TEXT([Result]), (FIND(".", TEXT([Result])) + 1), LEN(TEXT([Result])))) : Extracts the fractional component of the Decimal-type value in the Result column:

  • TEXT([Result]) converts the Decimal value to a Text value. The textual functions used in this example interpret non-textual values differently. Using TEXT() ensures the Result column value is interpreted the same by each function.
  • FIND(".", ...) + 1 locates the beginning of the fractional component as the position immediately after the decimal point in the value.
  • MID(..., ..., LEN(...)) extracts the fractional part using a how-many value guaranteed to cover the entire fractional component.
  • NUMBER(...) converts the extracted text to a Number.

See also: FIND(), LEN(), NUMBER(), TEXT()

See Also

INITIALS(), LEFT(), RIGHT()

Did this answer your question?