[Skimmertalk] software to manage raw data files

[Jorge Diez - CX6VM]

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