all. I want to rename 970 files in a folder. The name is like this "ENCFF207HQD.bam" and so on. And the prefix I want to use is in an excel. The existing prefix is in the second column, and the prefix I want to use is in the third column, How to use information in the excel to rename all the files correctly each by each. Thanks!
excel like this:
9 ENCFF006UXO ETS1-human 10 ENCFF468AKT ETS1-human 11 ENCFF000YFF ATF1-human 12 ENCFF000YFI ATF1-human 13 ENCFF990JRT GATA2-human 14 ENCFF778HCA GATA2-human 15 ENCFF257UWF EZH2-human 16 ENCFF083IDB EZH2-human 17 ENCFF788FFM HDAC8-human