[Skimmertalk] software to manage raw data files

David Gilbert xdavid at cis-broadband.com
Tue Feb 21 16:52:18 PST 2012



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
>


More information about the Skimmertalk mailing list