Find and Replace Query or Macro

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
c:\w2kdata\pdffiles\2006\another.pdf

I would like to shorten all imported paths to
pdffiles\whatever

Example;
pdffiles\2005\somepdf.pdf
pdffiles\2005\january\someother.pdf
pdffiles\2006\another.pdf
and so on