Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could I use Vlookup?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |