Here is my case:
I have a lot of excel file named like:
"aaa CPU Utilization 31Dec2024-31Dec2024.xlsx"
"bbb Disk Utilization 31Dec2024-31Dec2024.xlsx"
etc.
I need to move them to another folder like:
aaa CPU Utilization 31Jan2024-31Jan2024.xlsx -> 2024-01-02 (yyyy-MM-MM)
aaa CPU Utilization 31Feb2024-31Feb2024.xlsx -> 2024-01-02
...
aaa CPU Utilization 31Nov2024-31Nov2024.xlsx -> 2024-11-12
aaa CPU Utilization 31Dec2024-31Dec2024.xlsx -> 2024-11-12
and if the file not exist it will auto create a folder.
is it possible?