If these numbers are one to a line and in a text file, you could use the
old sort program from dos at a command prompt. I know dos is dead, but
I still use it for some stuff. If you sorted the file, all of the same
numbers should be grouped together and you could delete all but one.
You can tell it what column to sort on also. I used it recently to sort
the lilst of songs in my juke box. I wanted one one list by letter and
another list by the name of the song. Just a thought.
73
Butch
WA0VJR
Node 3148
Wallace, ks.
On Tue, 6 Dec 2016,
David via Talk wrote:
Not aware of any database that would be doing exactly this. Though I am
not very familiar with commercial databases either.
I'd say, this whole thing would be quickly and easily done, by a few
lines of scripting. It is but one example, where scripting takes the
bigger bite, over any full-fledged piece of software, simply because you
can make the script do it the way you want.
Without promising anything further, you are welcome to get in touch
OFF-LIST, to discuss further scripting solution. Until I know more
details on the project, I am not going to promise anything at all.
All of this, just based on the information your message provided.
Contact at:
[email protected]
David
On 12/6/2016 2:45 AM, Dave via Talk wrote:
Hello, Maybe someone here can give me an easier solution?
At my work, the Customer Service department has had a huge break down of
their Phone system. Voice mail is gone, but the system does record the
callers number.
I've been given almost two months worth of calls that have come in and
they want me to work with this list to remove all duplicates. There
are Hundreds of phone numbers in this list.
These numbers need to be Hand Typed into something, such as MS Word, so
they can be printed out and then Customer Service can call them back.
I am thinking there must be some way to detect duplicate numbers,
meaning someone has called in multiple times attempting to get to
someone in Customer Service.
Since these numbers will be getting manually typed into something, I am
open to any suggestions as to what would work for removing duplicate
numbers.
I thought of a Database, but Win eyes doesn't seem to work that well
with a Database. I could type them all into a Spread sheet, but I am
not familiar with all the features in spread sheets. Is there one that
would detect and tell me the duplications?
Anyone have any suggestions how to solve this problem?
Grumpy Dave
_______________________________________________
Any views or opinions presented in this email are solely those of the author
and do not necessarily represent those of Ai Squared.
For membership options, visit
http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/butchb%40shellworld.net.
For subscription options, visit
http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com
List archives can be found at
http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
_______________________________________________
Any views or opinions presented in this email are solely those of the author
and do not necessarily represent those of Ai Squared.
For membership options, visit
http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com.
For subscription options, visit
http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com
List archives can be found at
http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
