I have nearly 4,000 image files that I need to rename. They all contain one type of unique ID number (let's call it ID1) along with some other words, and I need to rename them to a different type of unique ID number (let's call it ID2) without the other words. I have the 4,000 ID1 numbers and the ID2 numbers that go along with each one in an excel sheet. Is there a way to do a find and replace that will find each unique ID1 regardless of other words in the name, and replace the entire name with ID2? Here is an example of what I need done:
Original File Name: "Discovery.123456.jpg"
What I need to change it to: "789123.jpg"
All 4,000 files are named individually, and I need to change them to different individual names.