How to update a column of Hyperlinks as a group

Options

Hi

I have a data base within which has a column with hyperlinks to key information documents. The file location of these documents has been updated from a 'draft' file location to a 'final' file location as we have now complete this stage of the project. The file structure under the main folder has been maintained.

As a result the hyperlinks in our data base no longer work. We need to update the beginning of the hyperlink details only - ie: "H/Draft/Process 1" to "M/Final/Process 1".

Is there a way to do a find and replace within the hyperlinks, rather than having to individually update all the links?

Thanks

Michelle

Answers