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!
Solved! Go to Solution.
Step 1: Input
Next step:
Next step:
Nest step;
Next step:
Here is the output;
Many thanks
Shanker V
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: