JayDP123
07-16-2010, 12:55 PM
Hey
I have a column filled with 5 digit values (00007,00085,00176).
I also have a column with path filenames which include that same number along with many other values (ABC12DE34_ABCD_12_00085_ABC.jpg). For example the "00085" would be the value in question.
These 2 values are not always on the same row. I would like to create a code that will ensure that the long file path name gets placed onto the same row as its corresponding 5-digit number.
This is important as I will be deleting the .jpg files, and would prefer not to delete the incorrect files!!
Thanks.
:dunno
I have a column filled with 5 digit values (00007,00085,00176).
I also have a column with path filenames which include that same number along with many other values (ABC12DE34_ABCD_12_00085_ABC.jpg). For example the "00085" would be the value in question.
These 2 values are not always on the same row. I would like to create a code that will ensure that the long file path name gets placed onto the same row as its corresponding 5-digit number.
This is important as I will be deleting the .jpg files, and would prefer not to delete the incorrect files!!
Thanks.
:dunno