Date: Thu, 21 Sep 2006 22:09:03 -0700 (PDT) From: "Freddie Cash" <fcash@ocis.net> To: "Matt Emmerton" <matt@gsicomp.on.ca> Cc: stable@freebsd.org Subject: Re: sed and comma-delimited file Message-ID: <60472.24.70.153.246.1158901743.squirrel@webmail.sd73.bc.ca> In-Reply-To: <002101c6dc46$470b1d50$0000fea9@gsicomp.on.ca> References: <c04d7e300609190926t1e5dce14wea7ef1a16ccf9af1@mail.gmail.com> <54894.192.168.0.10.1158706436.squirrel@webmail.sd73.bc.ca> <002101c6dc46$470b1d50$0000fea9@gsicomp.on.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, September 19, 2006 4:49 pm, Matt Emmerton wrote:
>> On Tue, September 19, 2006 9:26 am, SigmaX asdf wrote:
>>> I have a series of comma-delimited text files with fourteen
>>> columns of data and several hundred rows. I want to use a short
>>> shell script to strip them of the last 9 columns, leaving the same
>>> file but with just five of its columns. I can do it in C++, but
>>> that seems like overkill. How would I go about doing it with sed
>>> or a similar utility?
>> cat file | awk -F"," '{ printf "%s,%s,%s,%s,%s\n",$1,$2,$3,$4,$5
>> }' > newfile
> What's wrong with this?
> cat file | cut -f-5 -c';' > newfile
[shrug] It uses cut, which I've never used or even heard of??? :)
----
Freddie Cash
fcash@ocis.net
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?60472.24.70.153.246.1158901743.squirrel>