How to update a column of Hyperlinks as a group
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?