Turning a long list of keywords into links automaticaly

Forum Moderators: phranque

Message Too Old, No Replies

Turning a long list of keywords into links automaticaly

How would you do this?

Sgt_Kickaxe

6:43 pm on May 21, 2010 (gmt 0)

I have a long list of keywords that I need converted into relative links. How would I go about doing this with a text editor? Does a script already exist for this?

big widget needs to be turned into <a href="big-widget" title="big widget">big widget</a> as do the other 500 keywords on that list (which has them listed one per line atm). In notepadd++ for example, how ?

lammert

6:47 am on May 22, 2010 (gmt 0)

A stream editor would be the ideal tool for this. If you have access to a linux system, this can be implemented in one line of AWK. AWK is also available for windows systems.

HeyJim

5:42 pm on May 25, 2010 (gmt 0)

Use Excel or probably any other spreadsheet.

Column 1 type in as text
<a href="

Column 2
Paste your urls

Column 3
">

Column 4
Your 500 keywords

Column 5
</a>

Column 6
Do something like this:
=F40&G40&H40&I40&J40

That above is for me to cover row 40, columns F through J in my case.

Remember in columns 1, 3, and 6 you can drag the contents down the rows as far as you need it done. In your case, 500 rows.