[Skimmertalk] software to manage raw data files

Pete Smith N4ZR n4zr at contesting.com
Wed Feb 22 13:45:40 PST 2012


Which is why Access is your best bet.  I did all my analysis on the CQWW 
CW (1.8 +1.7 million lines) with Access.

73, Pete N4ZR
The World Contest Station Database, updated daily at www.conteststations.com
The Reverse Beacon Network at http://reversebeacon.net, blog at reversebeacon.blogspot.com,
spots at telnet.reversebeacon.net, port 7000 and
arcluster.reversebeacon.net, port 7000


On 2/22/2012 10:30 AM, Jorge Diez - CX6VM wrote:
> Thanks Mark,
>
> The original idea was to have ONE file, so I can filter by columns with data
> of all the contest.
>
> 73,
> Jorge
>
>
> -----Mensaje original-----
> De: skimmertalk-bounces at contesting.com
> [mailto:skimmertalk-bounces at contesting.com] En nombre de Mark Bailey
> Enviado el: Miércoles, 22 de Febrero de 2012 01:10 p.m.
> Para: skimmertalk at contesting.com
> Asunto: Re: [Skimmertalk] software to manage raw data files
>
> The GnuUtils package has a program called "split" which will split a
> single file (in this case, a large .csv file) into chunks of any number
> of lines.
>
> You can install GnuUtils from the "Setup" link on
> http://gnuwin32.sourceforge.net/packages/coreutils.htm
>
> "c:\program files\Gnuwin\bin" has to be in the path.
>
> split -l 1000000 20120218.csv
>
> will split the csv file into chunks of 1000000 lines.  Excel can read
> those.  The files end up with names like "xaa", "xab", etc..
>
> 73,
>
> Mark, KD4D
>
> On 2/22/2012 9:49 AM, Paul_group wrote:
>> On 22/02/2012 03:57, Luc Moreira wrote:
>>> OpenOffice can do the job. No row limit and fast filtering RBN raw data.
>>>
>>> http://www.openoffice.org/download/index.html
>>>
>>> 73, Luc
>>>
>> As far as I can see, OpenOffice calc 3.3 is limited to 1048575 rows
>> which allows you to see about 75% of the data in a busy contest / day
>> (00:00UTC to 20:16UTC on the 18th Feb for example)
>>
>> I may be missing something.
>>
>> --
>> 73 de Paul GW8IZR  IO73TI
>> http://www.gw8izr.com
>> _______________________________________________
>> Skimmertalk mailing list
>> Skimmertalk at contesting.com
>> http://dayton.contesting.com/mailman/listinfo/skimmertalk
>>
> _______________________________________________
> Skimmertalk mailing list
> Skimmertalk at contesting.com
> http://dayton.contesting.com/mailman/listinfo/skimmertalk
> -----
> Se certifico que el correo no contiene virus.
> Comprobada por AVG - www.avg.es
> Version: 2012.0.1913 / Base de datos de virus: 2113/4825 - Fecha de la
> version: 22/02/2012
>
> _______________________________________________
> Skimmertalk mailing list
> Skimmertalk at contesting.com
> http://dayton.contesting.com/mailman/listinfo/skimmertalk
>
>


More information about the Skimmertalk mailing list