Reading month number from Excel file name

Hi All,

I currently have a folder with monthly reports named like ‘Report - FYTD June 18’, but the date/month is not contained in any column in the data.

I’m using a loop to read all the files in that folder. Is there a way that I can read the month number in the file name and append that as a column for each iteration of the loop?

Any input or thought will be much appreciated!

Best regards
JX

I attached a workflow that demonstrates how it could be done.

kn_example_read_excel_file_name.knwf (53.5 KB)

2 Likes

You can also look at:

Hi mlauber71,

Thanks so much, the workflow works perfectly!

1 Like

Hi izaychik63,

I think the default Date Field Extractor (legacy) works fine in this case!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.