Find and Replace

kitty77

Registered User.
Local time
Today, 10:39
Joined
May 27, 2019
Messages
715
I'm trying to do a find and replace on a hyperlink field...

Find "\AMN\AMN\" and Replace it with "\PRO\PRO\"

Here is what the data looks like for find: \\SERVER\Test Folder Now\AMN\AMN\Results\19329.pdf
But when it replaces, it gives me this: file:///\\SERVER\Test%Folder%Now\PRO\PRO\Results\19329.pdf

Why is it putting the file:/// and "%" when it replaces? How can I fix this? Export it first?

Thanks!
 
The % is the official notation for a space in the hyperlink
File is because you are pointing to a file

The link should still work? Have you tried the new link?

Why do the replace in the first place?
 
Thanks. Looks like if I copy into excel, then paste back into Access it works or views the same.
Why? Because the file location changed.
 
Well if your DB changed with it as well, perhaps you can use a relative filepath instead.
 
The % is the official notation for a space in the hyperlink
Not quite.
The percent is an escape character. What follows it defines the character
%20 designates a space.
 
So, when I copy into excel, then back into Access, the data looks correct and formatted the way I'm looking for.
But the target for the hyperlink is not there?
 

Users who are viewing this thread

Back
Top Bottom