> 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](/files/-MY7XwdnfG4xVraFrJkC)

## 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](/files/-MY7XwdoJbSi5w0BYsLb)