toggle quoted messageShow quoted text
I do just what Michael has described.
You don't need a computer with Linux however but it is easier to get going.
On a Windows computer you can install many of the common *NIX command line tools available in
and there are other WIN32 GNU command line tools sources as well.
BUT, these are not for everyone.
an alternative already exists with Windows.
There is a command line tool called FINDSTR.
Open a cmd.exe window and enter: help findstr and you fill a simple listing of how to use this tool
findstr will search a specified file for a specified string just like using grep in Michaels example.
for example, at the c: prompt: findstr callsignToSearchFor wsprFile.csv > results.csv
This will search wsprFile.csv for the string CallsignToSearchFor and will put the results in file results.csv
This will reduce that very large .csv file down to something more manageable that Excel can import.
Also, SQLite is a very good alternative to using Microsoft Access if you wished to go that way.
cheers, Graham ve3gtc
On Thu, Jun 11, 2020 at 1:24 PM Michael Babineau <mbabineau.ve3wmb@...> wrote: