Find and Replace (1 Viewer)

kitty77

Registered User.
Local time
Today, 02:21
Joined
May 27, 2019
Messages
415
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!
 

namliam

The Mailman - AWF VIP
Local time
Today, 08:21
Joined
Aug 11, 2003
Messages
11,696
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?
 

kitty77

Registered User.
Local time
Today, 02:21
Joined
May 27, 2019
Messages
415
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.
 

namliam

The Mailman - AWF VIP
Local time
Today, 08:21
Joined
Aug 11, 2003
Messages
11,696
Well if your DB changed with it as well, perhaps you can use a relative filepath instead.
 

Galaxiom

Super Moderator
Staff member
Local time
Today, 18:21
Joined
Jan 20, 2009
Messages
12,395
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.
 

kitty77

Registered User.
Local time
Today, 02:21
Joined
May 27, 2019
Messages
415
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

Top Bottom