Extract only month from filename

Miryana_26

Hi I have a dataset with a lot of files that are named identically but for the different months.

The naming is : YY-MM-DD I want to create a formula only extracting the months from the file name.

Example of filenames:

Test_Database_2022-10-13

Test_Database_2022-01-02

Test_Database_2022-02-01

So, in this case at the end I should have months October (10), January (01) and February (02).

Can you help me create a formula? Thanks a lot!

Datasets

Accepted answers

DataNath

Hey @Miryana_26, if your file names really are identical and always just end in the date, then you can use a simple string function - Right() - to isolate these last 10 characters and then just parse that Date as you wish:

Parse month names+numbers from filename.yxmd

All comments

gabrielvilella

You can use Regex.

REGEX_Replace([FileName], '.+\d+-(\d+)-\d+.+', '$1')

Month.yxmd

ShankerV

Hi @Miryana_26

One way to achieve the solution is as below

Many thanks

Shanker V

ShankerV

Step 1: Input

Next step:

Nest step;

Next step:

Here is the output;

Many thanks

Shanker V

DenisZ

Please see attached workflow, hope it helps

ExtractMonth.yxmd

binu_acs

@Miryana_26 One way of doing this

MonthName_1117.yxmd

DataNath

Parse month names+numbers from filename.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703