[Skimmertalk] software to manage raw data files

[Jorge Diez - CX6VM]

Thanks Luc!!!

Abrazo,
Jorge



-----Mensaje original-----
De: skimmertalk-bounces at contesting.com
[mailto:skimmertalk-bounces at contesting.com] En nombre de Luc Moreira
Enviado el: Miércoles, 22 de Febrero de 2012 01:58 a.m.
Para: skimmertalk at contesting.com
Asunto: Re: [Skimmertalk] software to manage raw data files

OpenOffice can do the job. No row limit and fast filtering RBN raw data.

http://www.openoffice.org/download/index.html

73, Luc
__
PW7T Team member
WRTC.2010 Brazilian Team Leader
PY8AZT (also PT7AG, PX8C, ZZ8Z, ZY7C)
LABRE, ARRL, CWJF & Fortaleza DX Group Member





Em 21 de fevereiro de 2012 22:59, Timothy Coker <n6win73 at gmail.com>escreveu:

> I did what Dave mentions but just pasted each half into seperate sheets in
> one work book after importing each half-file into seperate Excel
workbooks.
>
> 73,
>
> Tim /N6WIN.
> On Feb 21, 2012 4:52 PM, "David Gilbert" <xdavid at cis-broadband.com> wrote:
>
> >
> >
> > One possibility might be to break up the TXT file into multiple files
> > that each have less than 1 million lines.  Load each one into separate
> > EXCEL files, then cut/paste them all into a master EXCEL file with
> > multiple groups of columns.  In other words, if you had three EXCEL
> > files each approximately 1 million lines and six columns each, you'd end
> > up with a master file that had the data from the first file in columns A
> > through F, the data from the second file maybe in columns K through P,
> > and the data from the third file in columns U through Z.   You'd have to
> > do your analysis on all three groups of columns but with some thought
> > you should be able to write the formulas to handle everything.
> >
> > At least I THINK that should work ...  ;)
> >
> > 73,
> > Dave   AB7E
> >
> >
> >
> > On 2/21/2012 2:26 PM, Jorge Diez - CX6VM wrote:
> > > Hello,
> > >
> > >
> > >
> > > Is there any software that allow filtering columns in a big file?
> > >
> > >
> > >
> > > I downloaded raw data from http://www.reversebeacon.net/ from February
> > 18
> > > (ARRLDX CW), I rename the file to TXT and open it with Microsoft
Excel,
> > but
> > > it open till 1.048.576 line (20:56 utc) so I am missing some lines to
> > > complete the day.
> > >
> > >
> > >
> > > Worst is that I want to do a unique file with both days of the
contest!
> > >
> > >
> > >
> > > So Microsoft Excel don´t work for that. Do you know another software
> that
> > > can do a column filtering in a file like this?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Jorge
> > >
> > > CX6VM/CW5W
> > >
> > > _______________________________________________
> > > 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
> >
> _______________________________________________
> 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 certificó que el correo no contiene virus.
Comprobada por AVG - www.avg.es
Versión: 2012.0.1913 / Base de datos de virus: 2113/4823 - Fecha de la
versión: 21/02/2012