I renamed all my digital and scanned photos but I have applications
that refers to the old names and directories.
I want to replace the old names & directories with the new names and
the new directories for all those jpg file .

On sheet 1, I have in col A, all the new directory & filename
and in Col B, all the old file name only (the old directory is not
there)
There are 1500 lines (pictures) that were renamed. (sorted on col B)

Col A Col B
E:\My PICTURES\2004\20040326_1715.jpg hawai.jpg
E:\My PICTURES\2004\20040326_1698.jpg Kat25.jpg
E:\My PICTURES\2004\20040326_1700.jpg LLLL.jpg
E:\My PICTURES\2004\20040508_1697.jpg L05_0592.JPG

On sheet 2, I copied one of the many txt files of an application where
we can find lines
that refers to the old directory and filename of a picture.

lines...
cell[2].images[0].image=../../../E:\My PICTURES\Fam/Friends\kat25_.jpg
lines...
cell[32].images[0].image=../../../E:\My PICTURES\Fam/Friends\Kito6.jpg
lines...
cell[151].images[0].image=../../../E:\MyPICTURES\Others/cats\IMG_0256.JPG
lines...

I want to replace this old directory and filename
E:/My Pictures/Fam/Friends/kat25_.jpg
with the new directory and filename;
E:\My Pictures\2004\20040326_1698.jpg
but also keep the information that preceded the old filename &
directory.

Final result on sheet 2 should be;
cell[2].images[0].image=../../../E:\My Pictures\2004/20040326_1698.jpg

Any suggestions on a possible solution?

Den