> For the complete documentation index, see [llms.txt](https://hi-primus.gitbook.io/bumblebee/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://hi-primus.gitbook.io/bumblebee/transformations/transformation-functions/string-functions/mid_string.md).

# Mid (substring)

Extracts a given number of characters from the values of a string and outputs the result to a new column or to the same input column. This operation is useful for quickly extracting data from fixed-length values.

## Location

![Mid (substring) on the interface](https://1348350781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MV2mHcaOiKNDfEbfXux%2Fsync%2Fcd86d20690593cc92cf7de7730ff3b9069f44b67.png?generation=1618272342202914\&alt=media)

## Fields

| Field                 | Type       | Description                                                                          |
| --------------------- | ---------- | ------------------------------------------------------------------------------------ |
| Output column name(s) | Text field | Name of the output column(s), if left blank will save the result on the same column. |
| Start at              | Numeric    |                                                                                      |
| End at                | Numeric    |                                                                                      |

## Example

![Mid (substring) example](https://1348350781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MV2mHcaOiKNDfEbfXux%2Fsync%2F50c59948d6feded83525fbedd6d4a171777444e2.png?generation=1618272342299296\&alt=media)