homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Marketing and Biz Dev / Keyword Discussion
Forum Library, Charter, Moderator: open

Keyword Discussion Forum

How can I weed out the dupes from my keyword list?

 1:14 pm on May 31, 2001 (gmt 0)

I have a list of 600 keywords and many of them are duplicates.
Does anyone know of a program that will find duplicates in a list
and highlight them or remove them?
I have Textpad and Dreamweaver. It doesn't look like these will do it but I'm not sure.



 8:18 pm on May 31, 2001 (gmt 0)

I use a spreadsheet program like Excel to sort a list alphabetically -- then the dupes stand out for easy removal.
If the keywords are comma separated in a text file, it's easy to rename the file extentension from .txt to .csv and then open that file in a spreadsheet program.

There may be a more elegant way, but this method does do the job.


 11:51 pm on May 31, 2001 (gmt 0)

or, assuming you have a list of keywords only and not associated data, import them into Access (or FileMaker Pro or any other similar database program) with the keyword field set to "Indexing no duplicates". Done!



 12:41 am on Jun 1, 2001 (gmt 0)

Perlyking, that is cool. I got something along the same lines, but it doesn't do the metatag thing. It is more for weeding out kw dupes from a raw collection.


 2:15 am on Jun 1, 2001 (gmt 0)

Excellent info! I knew I'd get answers here.
I don't know anything about databases and spreadsheets unfortunately, but that webpage will do the trick.


 2:25 am on Jun 1, 2001 (gmt 0)

That webpage is separating my keyword phrases into single words.
Maybe I'm doing something wrong, I don't know.


 9:05 am on Jun 1, 2001 (gmt 0)

littleman, thanks :) - its a variation of my [url=www.tarbard.co.uk/content/internettools.shtml]other script[/url] where you supply a URL and it downloads the page and generates keywords from that.

Lizzie, sorry it separates on white space. You could try doing a find and replace on your list to replace all spaces with dashes, then run it through then find and replace to put the spaces back.

Or I might have a play and change it..

update: Theres now a "lizzie mode" that should be ok with phrases - (just one small bug..)


 3:27 am on Jun 2, 2001 (gmt 0)

>>I have Textpad and Dreamweaver. It doesn't look like these will do it but I'm not sure.

Hi Lizzie, If you have the latest version of Textpad (not sure if older versions have it) you can remove the duplicates from the sort window.

Open your keywords file

Click Tools on the menu bar

Then select Sort...

Then select the Delete Duplicate Lines check box

That's it! It should remove any duplicate keywords as long as they are listed like..

and so on


 2:39 am on Jun 3, 2001 (gmt 0)

Perfect! Thanks!

Global Options:
 top home search open messages active posts  

Home / Forums Index / Marketing and Biz Dev / Keyword Discussion
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved