logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Unique Calls
TF5B
#1 Posted : Wednesday, February 17, 2016 10:32:59 AM(UTC)
Billi

Rank: Advanced Member

Groups: Registered
Posts: 36
Location: Akureyri Iceland

Was thanked: 4 time(s) in 4 post(s)
Hello there.
I would like to know how many unique callsigns are in my 75.000 qso´s log file.
I have been looking for this in Logic but have not been alble to find anything about this.
Some stations I have worked once and some 20 to 30 times but I would like to know how many unique calls there are in the log.
Any help woluld be appreciated.
73 Billi TF5B
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Thursday, February 18, 2016 9:49:41 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,097
Man
Location: Auburn, GA

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
Hi Billi--

Nice to meet you via your picture.

This is an easy one -- the only kind I am doing today hihi.

Go to tools/advanced/database commands. Type:

select distinct call from log

A window will open showing each call once. it perfectly covers the database commands window, so move it aside or close it, and look at the status bar at the bottom of the window. It will show 1/xxxx, where xxxx is the number of distinct calls.

BTW you can get total call count by doing the same thing, but omitting DISTINCT from the command.

Tnx & 73,

Dennis WN4AZY
TF5B
#3 Posted : Thursday, February 18, 2016 10:09:46 AM(UTC)
Billi

Rank: Advanced Member

Groups: Registered
Posts: 36
Location: Akureyri Iceland

Was thanked: 4 time(s) in 4 post(s)
Thank you Dennis. this is exactly what I wanted.
Now I know that I do have 40.406 unique calls in my log.
Again thank you Dennis.
73 Billi TF5B
Users browsing this topic
Guest (2)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.025 seconds.