## Examples

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

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

### Fractional Component of Decimal Value

The integer component of a Decimal value in the Result column:

``NUMBER(  MID(    TEXT([Result]),    (FIND(".", TEXT([Result])) + 1),    LEN(TEXT([Result]))  ))``
• `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.

## Syntax

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

## Arguments

• some-text (any textual type)
• begin-at (Number) : The position, equal to or greater than 1, of the first character in some-text to return. A non-Number value may be accepted but may produce unexpected results.
• how-many (Number) : The non-negative number of characters from some-text to return. A non-Number value may be accepted but may produce unexpected results.

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