Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > HTML > email Column in table - utility to convert into mailto: addresses

Reply
Thread Tools

email Column in table - utility to convert into mailto: addresses

 
 
©®
Guest
Posts: n/a
 
      05-12-2004
I have a table in my document (name, phone, email) and have about
150-200 different email addresses in the "email" column. They are in
plain text with no links.
Is there an automated way (in Dreamweaver or a 3rd party add-on) that I
can convert that whole column into linkable email addresses so that when
someone clicks on the address, it will open their email program?

I am hoping I don't have to manually copy each address and then add
"mailto:" to each address.
Each address field corresponds to the name of the person. Some names are
husband/wife and they are in alphabetical order.

e.g.
adam bullin
tom gregg
betty smith
john smith
tommy tomlin

I want it to be:

adam bullin
tom gregg
betty smith
john smith
tommy tomlin


 
Reply With Quote
 
 
 
 
©®
Guest
Posts: n/a
 
      05-12-2004
Sorry...the first set of names were not supposed to be hyperlinked. I
hope you understand what I was meaning!


 
Reply With Quote
 
 
 
 
Els
Guest
Posts: n/a
 
      05-12-2004
©® wrote:
> I have a table in my document (name, phone, email) and have about
> 150-200 different email addresses in the "email" column. They are in
> plain text with no links.
> Is there an automated way (in Dreamweaver or a 3rd party add-on) that I
> can convert that whole column into linkable email addresses so that when
> someone clicks on the address, it will open their email program?
>
> I am hoping I don't have to manually copy each address and then add
> "mailto:" to each address.


Probably possible in Dreamweaver, but I don't know that
program. I find it very easy to do in TextPad, using the
macro function.
http://textpad.com/


--
Els
http://locusmeus.com/
Sonhos vem. Sonhos vão. O resto é imperfeito.
- Renato Russo -

 
Reply With Quote
 
Shahid Juma
Guest
Posts: n/a
 
      05-12-2004
One way that I can think of is you can past the three columns into Excel

4th column: <a href="mailto:
5th column: "</a>
6th column: concat (4th column, email column, 6th column)

Then just copy the first 2 columns and the 6th one and paste it into an
editor like Dreamweaver which will recognize the columns/rows...

Shahid
(remove NOSPAM from the email address when replying to my email address)

"©®" <> wrote in message
news:40a25f46$0$6320$. ..
> I have a table in my document (name, phone, email) and have about
> 150-200 different email addresses in the "email" column. They are in
> plain text with no links.
> Is there an automated way (in Dreamweaver or a 3rd party add-on) that I
> can convert that whole column into linkable email addresses so that when
> someone clicks on the address, it will open their email program?
>
> I am hoping I don't have to manually copy each address and then add
> "mailto:" to each address.
> Each address field corresponds to the name of the person. Some names are
> husband/wife and they are in alphabetical order.
>
> e.g.
> adam bullin
> tom gregg
> betty smith
> john smith
> tommy tomlin
>
> I want it to be:
>
> adam bullin
> tom gregg
> betty smith
> john smith
> tommy tomlin
>
>



 
Reply With Quote
 
Beauregard T. Shagnasty
Guest
Posts: n/a
 
      05-12-2004
Quoth the raven ©®:

> I have a table in my document (name, phone, email) and have about
> 150-200 different email addresses in the "email" column.


Since these addresses will become "harvestable" by the spambots, have
these people given their permission for you to publish them?

--
-bts
-This space intentionally left blank.
 
Reply With Quote
 
Clive Moss
Guest
Posts: n/a
 
      05-12-2004

"Beauregard T. Shagnasty" <> wrote in message
news:Youoc.25865$...
> Quoth the raven ©®:
>
> > I have a table in my document (name, phone, email) and have about
> > 150-200 different email addresses in the "email" column.

>
> Since these addresses will become "harvestable" by the spambots, have
> these people given their permission for you to publish them?


> -bts

And even if they do give permission you should 'munge' the address
(http://www.mways.co.uk/prog/hidemail.php)

CM


 
Reply With Quote
 
©®
Guest
Posts: n/a
 
      05-12-2004
Clive Moss wrote:
>> Since these addresses will become "harvestable" by the spambots, have
>> these people given their permission for you to publish them?


> And even if they do give permission you should 'munge' the address
> (http://www.mways.co.uk/prog/hidemail.php)


Sorry - forgot to mention - it is an intranet so only the organisation
can access it. (Private phone list!)


 
Reply With Quote
 
©®
Guest
Posts: n/a
 
      05-12-2004
Shahid Juma wrote:
> One way that I can think of is you can past the three columns into
> Excel
>
> 4th column: <a href="mailto:
> 5th column: "</a>
> 6th column: concat (4th column, email column, 6th column)
>
> Then just copy the first 2 columns and the 6th one and paste it into
> an editor like Dreamweaver which will recognize the columns/rows...


Thanks - that was what I needed. FYI the 5th column should be: ' "</a>
as without the ' it will be right aligned and have no closing quote
(unless of course I misunderstood your info!)


 
Reply With Quote
 
Foofy (formerly known as Spaghetti)
Guest
Posts: n/a
 
      05-12-2004
On Wed, 12 May 2004 18:30:52 +0100, ©® <> wrote:

> I am hoping I don't have to manually copy each address and then add
> "mailto:" to each address.
> Each address field corresponds to the name of the person. Some names are
> husband/wife and they are in alphabetical order.


It seems like you already got your problem solved, but I did this sort of
thing once in EditPlus with it's regular expression find and replace
thingy.

Find: <td>(.+)@(.+)</td>
Replace with: <td><a href="mailto:\1@\2">\1@\2</a>

I wish more apps supported regular expressions in find and replace.


--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
 
Reply With Quote
 
Toby A Inkster
Guest
Posts: n/a
 
      05-13-2004
Foofy (formerly known as Spaghetti) wrote:

> I wish more apps supported regular expressions in find and replace.


http://www.openoffice.org/

--
Toby A Inkster BSc (Hons) ARCS
Contact Me - http://www.goddamn.co.uk/tobyink/?page=132

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Javascript Toolbox - Table Sort utility - Sort on column's @intattribute Rick Javascript 0 06-08-2010 11:44 PM
Javascript Toolbox - Table Sort utility - Column Width cannot be set. gandalfrat Javascript 6 03-08-2010 11:06 PM
Utility to convert complex declarations into, well, lol, plain-text nospam C Programming 11 05-03-2007 07:21 PM
Problem with comparing a Table View Column with the Table Column? savvy ASP .Net 1 01-18-2006 03:04 PM
Python utility convert Windows long file name into 8.3 DOS format Ben Kial Python 7 10-28-2004 12:38 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57