# Extract a String from a Specified Range

**URL:** <https://community.exploratory.io/t/extract-a-string-from-a-specified-range/4097>\
**Category:** Uncategorized\
**Created:** [November 20, 2025, 4:36am UTC](https://community.exploratory.io/t/extract-a-string-from-a-specified-range/4097 "2025-11-20T04:36:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Takato\_Shiroto](https://community.exploratory.io/user_avatar/community.exploratory.io/takato_shiroto/32/749_2.png) [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\
**Post date:** [November 20, 2025, 4:36am UTC](https://community.exploratory.io/t/extract-a-string-from-a-specified-range/4097/1 "2025-11-20T04:36:49Z")

</div>

When you import multiple CSV files, an “id” column is added. If you want to extract specific characters from a designated range, such as the “month” portion, you can do so.

 ![image](https://community.exploratory.io/uploads/default/original/2X/a/a37828a86e928e56df03797fbc9bd7be0c88d926.jpeg)

In this case, select “Extract” under “Work with Text Data” and then choose “Range of Text”

 ![image](https://community.exploratory.io/uploads/default/original/2X/d/d68111f62f91f016fa2cb4302c7c9a59ebf3e292.jpeg)

For this example, specify the character positions corresponding to the month in both the start and end fields.

 ![image](https://community.exploratory.io/uploads/default/original/2X/7/7a982320150278cd69919d63c83a8f3fd6db0f81.jpeg)

Alternatively, it may be easier to specify the range from the end. In that case, use a minus sign (-) to specify the position.

 ![image](https://community.exploratory.io/uploads/default/original/2X/f/f50867c77677ae1fab8fc276b5e8af714e17d603.jpeg)

By specifying the range, you can now extract the characters (in this case, the month portion).

 ![image](https://community.exploratory.io/uploads/default/original/2X/2/243f85dda70d1a983d44c1712b05cd96311fd759.jpeg)

If you want to execute this more easily, you can use the “AI Wrangling” feature.

 ![image](https://community.exploratory.io/uploads/default/original/2X/6/6dad31489e1e3a3906ee6499ce1170a1d2e3d70a.jpeg)

In the prompt, specify “Extract the month information from characters 15-16 in the id column”

 ![image](https://community.exploratory.io/uploads/default/original/2X/e/e295dad8c1d72bff980aacf2d321a891de61b5c6.png)

Using the AI prompt feature, you can easily extract only the month portion.

 ![image](https://community.exploratory.io/uploads/default/original/2X/a/a07073b451f26cbbfd4b8f0c9a45e714ea499e27.jpeg)