#email# (1 Viewer)

[jedder18]

email Field on a form setup as hyperlink.
Client would like to remove this, easy enough...
However, in our quest to remove link...notice that over half of the 9k+
addresses have extra added on to the end of email addy.

example: this is at end of email addylink

#mailto:myemail@yahoo.com#

any way to strip this out? and not manually?

Thanks in advance.

 

[XelaIrodavlas]

Is this a display issue on the form? if it is you should be able to hide the extra stuff by messing with the formatting, make sure it's property 'is hyperlink' is set to yes.

Otherwise I think HyperlinkPart will help.. see https://msdn.microsoft.com/en-us/library/bb225915(v=office.12).aspx

So simplest method, you could add the email field to a query like:

SELECT hyperlinkpart([EmailColumn],5) as Expr1
 FROM mytable;

and just copy/paste the results into whatever format you're after.

This should extract just the address, you could also take the displayed name/ other stuff, (see link again)

Hope this helps!

edit: that link seems to be bad :s just woogle 'application hyperlinkpart method'

 

[jedder18]

comes over to the table too....