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!
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!