how to copy hyperlink value to a new field automatically

J

John

Hello,
You might can help me on this.
Hyperlink--"Map",
The hyperlink value is"/y/Map.py?
Pyt=Typ&tuid=2986292&ck=3290351193&tab=B2C&
ycat=8227499&city=Andrews&state=NC&zip=28901&am
p;country=us&msa=5&slt=35.202000&sln=-
83.812900&cs=5&stat=:pos:0:regular:regT:1:fbT:0"
Point: one city with different zip code, so i have to use
this hyperlink to copy ZIP info to a new field.
Question:how can i use marcos or something eles to make it
automatically find MAP, and then copy hyperlink value and
then trim it left on six zip digits.
Thank you very much.
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top