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.
In this case, select “Extract” under “Work with Text Data” and then choose “Range of Text”
For this example, specify the character positions corresponding to the month in both the start and end fields.
Alternatively, it may be easier to specify the range from the end. In that case, use a minus sign (-) to specify the position.
By specifying the range, you can now extract the characters (in this case, the month portion).
If you want to execute this more easily, you can use the “AI Wrangling” feature.
In the prompt, specify “Extract the month information from characters 15-16 in the id column”
Using the AI prompt feature, you can easily extract only the month portion.
