I’m trying to rename my files. My file name syntax looks like this: AAA_BBB_CCC.xlsx where
BBB has 4 possibilities ‘football’,‘basketball’,‘volleybal’,‘rugby’.
If the file contains football then I should rename the file as AAA_1_CCC.xlsx.
If the file contains basketball then I should rename the file as AAA_2_CCC.xlsx
If the file contains volleyball then I should rename the file as AAA_3_CCC.xlsx
If the file contains rugby then I should rename my file as AAA_4_CCC.xlsx
Thanks in advance,