Keep the # signs out of hyperlinks and mailto

[James Ivey]

Access Newbie here.

I've got email addresses and website URLs formatted in the form as
hyperlinks.

When I export the data as a text file, the URL and mailto link have a # sign
on either side of them.

How do I export the data without the # signs?

James

 

[Allen Browne]

If you just want the address part of the hyperlink exported, type an
expression like this into the Field row in query design:
HyperlinkPart([MyField], 2)

Alternatively, just use a Text field instead of a hyperlink.

 

[James Ivey]

Thanks Allen. That works splendidly.

I changed it to:
HyperlinkPart([Email_Address],1)
to get rid of the mailto: and the http://

I tried using a text field, but then its not an active link.

I like being able to send the person an email while browsing records.

Of course, now the field header names are Expr1 and Expr2 rather than
Email_Address and Website... but I can live with it.

Thanks again.

James

If you just want the address part of the hyperlink exported, type an
expression like this into the Field row in query design:
HyperlinkPart([MyField], 2)

Alternatively, just use a Text field instead of a hyperlink.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Access Newbie here.

I've got email addresses and website URLs formatted in the form as
hyperlinks.

When I export the data as a text file, the URL and mailto link have a #
sign on either side of them.

How do I export the data without the # signs?

 

[James Ivey]

oh, for crying out loud... I think I'll just use text )

Thanks Allen. That works splendidly.

I changed it to:
HyperlinkPart([Email_Address],1)
to get rid of the mailto: and the http://

I tried using a text field, but then its not an active link.

I like being able to send the person an email while browsing records.

Of course, now the field header names are Expr1 and Expr2 rather than
Email_Address and Website... but I can live with it.

Thanks again.

James

If you just want the address part of the hyperlink exported, type an
expression like this into the Field row in query design:
HyperlinkPart([MyField], 2)

Alternatively, just use a Text field instead of a hyperlink.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Access Newbie here.

I've got email addresses and website URLs formatted in the form as
hyperlinks.

When I export the data as a text file, the URL and mailto link have a #
sign on either side of them.

How do I export the data without the # signs?