Jump to content

Sort found geocoins types by find count...


GeoLog81

Recommended Posts

I couldn't find a solution for you at geocaching.com.

Why do you need it?

 

Here is your current list down to 5 of the same icon (not necessarily 5 of the same coin):

 

Travel Bug Dog Tags 141

My Personal Geocoins 15

Geocaching Polska Geocoins 14

GeoGems 11

USA Geocoins 8

CC Geocoins 8

Appalachian Trail Geocoins 8

Mystic Pegasus Geocoins 7

Geocacher's License Geocoins 2007 6

Appalachian Trail 2008 Geocoins 6

Compass Rose Geocoin 2009 6

Mystic Naga Geocoins 6

Cachen ist die beste Medizin Geocoins 6

Mystic Gargoyle Geocoins 6

Geocaching – All In One Geocoin 2013 6

Mystic Garuda Geocoins 6

Inca Cross Geocoins 6

Royal Flush Geocoins 5

Nordic Caching Traveler Geocoins 5

Cacher Thermometer Geocoins 5

Travel Bug Origins - Deutschland 5

conivo’s Butterfly Geocoins 5

Six Pack of Beer Tags 5

Geocaching Basel Geocoins 5

 

This is how I did it:

 

1) go to your public list of trackables (the one list everyone can access)

2) save page as htm-file

-) When I tried to open it in 'open office', it crashed, probably because the file was too big and I was not patient enough to wait if it ever would wake up again. It may work for Excel... I don't know. So I did this:

3) open saved file with Windows editor

4) search for string "Trackables Moved" - there are two hits. The correct one is the first one that doesn't say "Total" in the same line

5) mark the <td>-Tag you can find three lines below

6) press ctrl+shift+Home to mark everything in the document before the table you want.

7) Press Delete to get rid of it. The first line in your document now should be <table class="Table">

8) search for string "Trackables Owned". Again, the first on is the correct one.

9) mark the </div>-Tag five lines up

10) press ctrl+shift+End to mark everything in the document after that line.

11) Press Delete to get rid of it. The last line in your document now should be </table>.

12) Save file as another name.

-) When I tried to open it in 'open office' it still crashed, probably because of all the icons....

13) Open the saved file in firefox/another browser. You get a table only with icons, names and counts.

14) press ctrl+A to mark all and ctrl+C to copy all

15) Start 'open office calc' (Excel might be able to do the same, but I don't own it)

-) Don't use the regular "paste"-function (made it crash again....)

16) Chooose Edit-> Insert content (may be labelled differently in English- I have a German version... it's ctrl+shift+V in open office)

-) Don't pick HTML (crash...)

17) Pick "unformatted text" - this gets rid of the icons.

18) I got a dialog how the content is supposed to be inserted. Make sure name and count is in different columns (I didn't have to change anything - the preview looked fine).

19) Then I had a nice two column file with the correct information. Now sort by Column Count (data-> sort)

 

If anyone knows an easier way, you're welcome to tell.

Edited by JoergWausW
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...