> 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/left_string.md).

# Left (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

![Left (substring) on the interface](https://1348350781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MV2mHcaOiKNDfEbfXux%2Fsync%2F9a179cc8d0c4db6a07b05228d413aa0edf2f8ef5.png?generation=1618272319010662\&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. |
| Characters to show    | Numeric    | The amount of characters to be shown.                                                |

## Example

![Left (substring) fields](https://1348350781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MV2mHcaOiKNDfEbfXux%2Fsync%2F015327ce18e700fe45119894abac6f72098511cc.png?generation=1618248143626225\&alt=media) ![Left (substring) example](https://1348350781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MV2mHcaOiKNDfEbfXux%2Fsync%2Fc09fc7ee382afbc8d7101385fde2a3ccdeade51d.png?generation=1618248145610376\&alt=media)