a way to batch automate url list to add href tags

Chffr · 2009-02-25, 02:54 PM

I'm not sure if such a script exist or not but I'm looking for a way to convert a list of 50 or so urls and add <a href=></a>. Free? Not free? Does it exist? Is there a way to do it in Excell?

I can do it by hand but I'd rather not.

Greenguy · 2009-02-25, 04:59 PM

You can do it in excell

In the 1st column:
<a href="

In the 2nd column the URL

In the 3rd column:
"></a>

In the 4th column you have to put in a formula:
=A1&""&B1&""&C1

The copy 1, 3 & 4 all the way down & 2 would be the list of URL's

OR

Instead of the 4th column, copy 1, 2 & 3 & paste them into a txt pad, then search & replace for a tab.

Chffr · 2009-02-25, 08:13 PM

Excell - lent!!!

Thanks Green Guy!

I used the =A1&""&B1&""&C1&""&D1&""&F1 formula. I included two more cells D1 & F1. I'll define it here in case anybody else needs the info.

A1=<a href="
B1=URL
C1=">
D1=Description text
F1=</a>

tickler · 2009-03-01, 01:48 PM

Quote:

Originally Posted by Greenie

You can do it in excell

In the 1st column:
<a href="

In the 2nd column the URL

In the 3rd column:
"></a>

In the 4th column you have to put in a formula:
=A1&""&B1&""&C1

The copy 1, 3 & 4 all the way down & 2 would be the list of URL's

OR

Instead of the 4th column, copy 1, 2 & 3 & paste them into a txt pad, then search & replace for a tab.

Or in excel use "absolute" references for 1 and 3

Chffr · 2009-02-25, 09:52 PM

oops...

scratch that...

I meant to say:

place formula =A1&""&B1&""&C1&""&D1&""&E1 into cell F1

A1=<a href="
B1=URL
C1=">
D1=Description text
E1=</a>
F1=Hyperlinked descriptive text

I'm having to save the URL's into a notepad doc then import them from file (delimited, separated by space into first cell). I do the same with the description text.

That should make more sense...and work.

LD · 2009-02-26, 03:08 PM

If you need to get rid of the formula that strings everything together in the last column and just have the text values, you can copy and paste special, then select "values." Usually not necessary, though.

Greenguy · 2009-02-26, 04:08 PM

...or just copy that column to a text page & then copy it from there back to the column.

2009-02-25, 02:54 PM	#1
Chffr A woman is like beer. They look good, they smell good, and you'd step over your own mother just to get one! Join Date: Feb 2009 Location: NYC Posts: 57	a way to batch automate url list to add href tags I'm not sure if such a script exist or not but I'm looking for a way to convert a list of 50 or so urls and add <a href=></a>. Free? Not free? Does it exist? Is there a way to do it in Excell? I can do it by hand but I'd rather not. __________________ Submit to CHuFFeRsLiST

2009-02-25, 04:59 PM	#2
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	You can do it in excell In the 1st column: <a href=" In the 2nd column the URL In the 3rd column: "></a> In the 4th column you have to put in a formula: =A1&""&B1&""&C1 The copy 1, 3 & 4 all the way down & 2 would be the list of URL's OR Instead of the 4th column, copy 1, 2 & 3 & paste them into a txt pad, then search & replace for a tab. __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network

2009-02-25, 08:13 PM	#3
Chffr A woman is like beer. They look good, they smell good, and you'd step over your own mother just to get one! Join Date: Feb 2009 Location: NYC Posts: 57	Excell - lent!!! Thanks Green Guy! I used the =A1&""&B1&""&C1&""&D1&""&F1 formula. I included two more cells D1 & F1. I'll define it here in case anybody else needs the info. A1=<a href=" B1=URL C1="> D1=Description text F1=</a> __________________ Submit to CHuFFeRsLiST

2009-02-25, 09:52 PM	#5
Chffr A woman is like beer. They look good, they smell good, and you'd step over your own mother just to get one! Join Date: Feb 2009 Location: NYC Posts: 57	oops... scratch that... I meant to say: place formula =A1&""&B1&""&C1&""&D1&""&E1 into cell F1 A1=<a href=" B1=URL C1="> D1=Description text E1=</a> F1=Hyperlinked descriptive text I'm having to save the URL's into a notepad doc then import them from file (delimited, separated by space into first cell). I do the same with the description text. That should make more sense...and work. __________________ Submit to CHuFFeRsLiST

2009-02-26, 03:08 PM	#6
LD wtfwjd? Join Date: May 2007 Posts: 2,103	If you need to get rid of the formula that strings everything together in the last column and just have the text values, you can copy and paste special, then select "values." Usually not necessary, though. __________________ Artisteer Wordpress Theme Generator Create Custom Themes! My Little Network

2009-02-26, 04:08 PM	#7
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	...or just copy that column to a text page & then copy it from there back to the column. __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network