I have folder CS with lots of excel files
ABCD_C01 April
XYXS_C02_May
I want to renaming all these files on the base of
file name contains April, may…..upto March
like
01_ABCD_C01 April
02_XYXS_C002 May
If file name contains April then add prefix 01_
If file name contains May then add prefix 02_
If file name contains June then add prefix 03_
If file name contains July then add prefix 04_
If file name contains August then add prefix 05_
If file name contains September then add prefix 06_
If file name contains October then add prefix 07_
If file name contains November then add prefix 08_
If file name contains December then add prefix 09_
If file name contains January then add prefix 10_
If file name contains February then add prefix 11_
If file name contains March then add prefix 12_
ABCD_C01 April
XYXS_C02_May
I want to renaming all these files on the base of
file name contains April, may…..upto March
like
01_ABCD_C01 April
02_XYXS_C002 May
If file name contains April then add prefix 01_
If file name contains May then add prefix 02_
If file name contains June then add prefix 03_
If file name contains July then add prefix 04_
If file name contains August then add prefix 05_
If file name contains September then add prefix 06_
If file name contains October then add prefix 07_
If file name contains November then add prefix 08_
If file name contains December then add prefix 09_
If file name contains January then add prefix 10_
If file name contains February then add prefix 11_
If file name contains March then add prefix 12_