Re: delete columns csv file

2008-04-03 Thread Rob Dixon
e-letter wrote: > Readers, > > I have a csv file (greater than 256 columns hence unable to open in > spreadsheet) of the following format: > > column header1, column header2, column header3 > 1,0.0e0,0.0e0,5e-6 > 2,0.0e0,0.0e0,6e-7 > 3,0.0e0,0.0e0,0.0e0 > > I want to perform: "if column headerx

Re: delete columns csv file

2008-04-03 Thread John W. Krahn
e-letter wrote: This may work for you: #!/usr/bin/perl use warnings; use strict; use Fcntl ':seek'; @ARGV = 'somefile.csv'; $^I = '.back'; my @headers = map 1, split /,/, <>, -1; my @keep = ( undef ) x @headers; while ( <> ) { chomp; my @fields = split /,/, $_, -1; for my $i ( 0 ..

Re: delete columns csv file

2008-04-03 Thread e-letter
> > This may work for you: > > > > #!/usr/bin/perl > > use warnings; > > use strict; > > use Fcntl ':seek'; > > > > @ARGV = 'somefile.csv'; > > $^I = '.back'; > > > > my @headers = map 1, split /,/, <>, -1; > > my @keep = ( undef ) x @headers; > > > > while ( <> ) { > >chomp; > >my @field

Re: delete columns csv file

2008-04-02 Thread John W. Krahn
John W. Krahn wrote: e-letter wrote: Readers, Hello, I have a csv file (greater than 256 columns hence unable to open in spreadsheet) of the following format: column header1, column header2, column header3 1,0.0e0,0.0e0,5e-6 2,0.0e0,0.0e0,6e-7 3,0.0e0,0.0e0,0.0e0 I want to perform: "if col

Re: delete columns csv file

2008-04-02 Thread John W. Krahn
e-letter wrote: Readers, Hello, I have a csv file (greater than 256 columns hence unable to open in spreadsheet) of the following format: column header1, column header2, column header3 1,0.0e0,0.0e0,5e-6 2,0.0e0,0.0e0,6e-7 3,0.0e0,0.0e0,0.0e0 I want to perform: "if column headerx contains o

Re: delete columns csv file

2008-04-02 Thread Rob Dixon
e-letter wrote: > > I have a csv file (greater than 256 columns hence unable to open in > spreadsheet) of the following format: > > column header1, column header2, column header3 > 1,0.0e0,0.0e0,5e-6 > 2,0.0e0,0.0e0,6e-7 > 3,0.0e0,0.0e0,0.0e0 > > I want to perform: "if column headerx contains on

delete columns csv file

2008-04-02 Thread e-letter
Readers, I have a csv file (greater than 256 columns hence unable to open in spreadsheet) of the following format: column header1, column header2, column header3 1,0.0e0,0.0e0,5e-6 2,0.0e0,0.0e0,6e-7 3,0.0e0,0.0e0,0.0e0 I want to perform: "if column headerx contains only values of 0.0e0, delete