Generate new name of file based on Original file name

Hello,

I have a list in excel of the files in folder. The filenames are of the form "1FT_DINRM_Bru_pt5GAL_TCL.wav". I want to rename the files with only numbers. The numbers are based as follows:

2021-08-15_23-13-11.png

For the filename given above, "1FT_DINRM_Bru_pt5GAL_TCL.wav", the output name to be generated will be "10003010500.wav". Another example for the file with an original name of "24FT10IN_Ane_Zm_4GAL_TCL_lclp.wav", the output file name will be "24100060240001.wav".

Is there a way to accomplish this? If so, can you tell me how to go about doing this? I was thinking along the lines of XLOOKUP?

For this use case, I would like to put the file names in one column, and the adjacent column will have the corresponding converted name.

Any help will be greatly appreciated.