Perl scripts to convert status.txt and cleared.txt into comma-separated form

[GP2]

The files status.txt and cleared.txt are available at:
http://www.mersenne.org/primenet/status.txt
http://www.mersenne.org/primenet/cleared.txt

These files are in a fixed-width format that is not necessarily convenient for data manipulation, and include a lot of non-data lines (header, footer, column headings).

The following converts the files first into the comma-separated files:
status_comma.txt
cleared_comma.txt

Then the files are further split into:
status_f.txt
status_l.txt
cleared_f.txt
cleared_l.txt
(with _f for factoring and and _l for LL assignments),
at which point status_comma.txt and cleared_comma.txt can be discarded.

    perl statusizer.pl status.txt > status_comma.txt
    perl -n -e 'print if /^[^,]*,.F,/' status_comma.txt > status_f.txt
    perl -n -e 'print unless /^[^,]*,.F,/' status_comma.txt > status_l.txt

    perl clearedizer.pl cleared.txt > cleared_comma.txt
    perl -n -e 'print if /^([^,]*,){2}.F,/' cleared_comma.txt > cleared_f.txt
    perl -n -e 'print unless /^([^,]*,){2}.F,/' cleared_comma.txt > cleared_l.txt

Perl is used because it is available on both Linux and Windows.

The scripts statusizer.pl and clearedizer.pl are attached.

[dsouza123]

If you are using windows what brand and version of perl do you use ( or if not using windows what do you recommend ) ?

Thanks for the scripts.

[GP2]

Originally posted by dsouza123
If you are using windows what brand and version of perl do you use ( or if not using windows what do you recommend ) ?

Thanks for the scripts.

Well actually I use Linux.

For Windows I think you can get ActiveState's version of Perl, but I've never personally used it.

[Xyzzy]

If you are running Windows, and you don't have Cygwin installed, then shame on you...

http://www.cygwin.com/

[GP2]

Originally posted by Xyzzy
http://www.cygwin.com/

Yes, perhaps Cygwin might be the best alternative.

All of my scripts for datamining the data files use standard Linux utilities like sort, uniq, cut, comm, join, paste and also sed, grep, perl. With Cygwin these become available on Windows too.