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!

[gabrielvilella]

You can use Regex.

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

[ShankerV]

Hi @Miryana_26 

One way to achieve the solution is as below

Many thanks

Shanker V

[ShankerV]

Step 1: Input

Next step:

Next step:

Nest step;

Next step:

Here is the output;

Many thanks

Shanker V

[DenisZ]

Please see attached workflow, hope it helps

[binuacs]

@Miryana_26 One way of doing this

[DataNath · Accepted solution]

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: