Search results

Thanks that does work. Yes I always backup my data. Where I made my mistake was not running it on the imported table, so of course if you take 11 spaces from the path when it doesn't need it... it don't work. I'm just learning here thanks for the great help... Great forum.

This removed everything at the beginning of the path including pdffiles/subfolders and part of some of the file name on some of them

Ok so how do I get it to remove the first part of the path and leve eveything starting with pdffiles/subfolders? The subfolders change as data is added.

This looks like asp code and I'm just running an access database...

What I'm wanting is to remove the first part of the path so the path always starts with pdffiles/subfolders. In doing this I can run it from any drive letter

ne1 help me with a find and replace query or macro. What I'm trying to do is shorten the path to external PDF files after I inport them into field TxtPDFPath. Example; after inport of files path reads c:\w2kdata\pdffiles\2005\somepdf.pdf c:\w2kdata\pdffiles\2005\january\someother.pdf...