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