I have these excel files in a user directory:

430_XFRtoDML.xlsx 431_XFRtoDML.xlsx 440_XFRtoDML.xlsx 450_XFRtoDML.xlsx 451_XFRtoDML.xlsx 465_XFRtoDML.xlsx 500_XFRtoDML.xlsx 

Path: /home/user

I want to write a script to create a text file bit_list.txt mentined below. It should remove the xlsx extension followed by :5. and first 3 number from that file. e.g. 430_XFRtoDML:5. 430

filenames=`ls *.xlsx` for eachfile in $filenames do echo $eachfile done 

Expected output:

$ cat bit_list.txt 430_XFRtoDML:5. 430 431_XFRtoDML:5. 431 440_XFRtoDML:5. 440 450_XFRtoDML:5. 450 451_XFRtoDML:5. 451 465_XFRtoDML:5. 465 500_XFRtoDML:5. 500