[Skimmertalk] software to manage raw data files

[Timothy Coker]

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
>