Welcome to WebmasterWorld Guest from 23.22.140.143

Forum Moderators: open

Message Too Old, No Replies

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

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

Preferred Member

10+ Year Member

joined:July 22, 2000
posts:385
votes: 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)

Senior Member

WebmasterWorld Senior Member tedster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:May 26, 2000
posts:37301
votes: 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.

Woz

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

Senior Member

WebmasterWorld Senior Member woz is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Aug 13, 2000
posts:4823
votes: 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!

Onya
Woz

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

Senior Member

WebmasterWorld Senior Member littleman is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:June 17, 2000
posts:2924
votes: 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 June 1, 2001 (gmt 0)

Preferred Member

10+ Year Member

joined:July 22, 2000
posts:385
votes: 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 June 1, 2001 (gmt 0)

Preferred Member

10+ Year Member

joined:July 22, 2000
posts:385
votes: 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 June 1, 2001 (gmt 0)

Preferred Member

10+ Year Member

joined:Feb 21, 2001
posts:419
votes: 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 June 2, 2001 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 29, 2000
posts:1425
votes: 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..

keyworda
keywordb
keywordc
keywordd
and so on

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

Preferred Member

10+ Year Member

joined:July 22, 2000
posts:385
votes: 0


Perfect! Thanks!