automagically turn a list of URLs into links?

[rainypickles]

format of the text file is

Description - http://thesite.com
Description - http://thesite.com
Description - http://thesite.com

how can i turn that text into html with only the URL linkified?

don't really know how to script. does word do it?

thanks!

 

[shortylickens]

I was gonna say just use the import and export option under IE's file menu, but that wouldnt fix your problem.

Hmmmmmm. I'll think on this and get back to you.

 

[bamacre]

Paste them in Excel, should automatically make links out of them.

Edit: Wait, maybe I misunderstood. Clarification?

If this is a text file, then open it in NotePad. Do a search and replace...

replace http://
with
<http://

Save the text file.

Open MS Excel. File - Open - change file type to .txt file, then select your text file. An import wizard will pop up. Choose Delimited rather than fixed-width. Use the < character as the delimiter. That will separate the description and the URL, and put each in a separate cell. The cells with the URL's will now be links. Save the page as HTML. Then use your HTML editor and edit as needed.

 

[rainypickles]

Originally posted by: bamacre
The cells with the URL's will now be links

thanks for the reply. the URLs are not links after i separate them to different columns. now you that you've reminded me, i remember i did this before. i did what you had said, and added some more columns. one column had (a href=" and the others were like (/a)(br) and such. (not parenthesis, actually less than and greater than, but i had problems posting). i saved that as a .csv file, and then in notepad searched and replaced all the commas and quotes with nothing. it worked, but it's pain.

i'll do that, but just wondering if anyone has a quicker way of doing this? url autoparse in something?

 

[IHateMyJob2004]

Post links in post here
view page source
profit

 

[rainypickles]

Originally posted by: IHateMyJob2004
Post links in post here
view page source
profit

thanks! wow, so elegant, yet so, hilarious. who would have thunk it, anandtech forums saves the day again.

i like this solution, but am surprised that there is no "clean" way to do this.

 

[mAdMaLuDaWg]

Originally posted by: IHateMyJob2004
1. Post links in post here
2. view page source
3. ???
4. PROFIT!

FIXED n00b!

 

[nweaver]

use a parsing language, such as perl. Very easy to write a quick loop,

open FILEHANDLE $file;
while FILEHANDLE {
goo here to find http and make it a href="http and fin the last .??? and make it .???>link</a>
}
should be a 10 minute affair, and then store it so you can use it next time.