sed and comma-delimited file
Freddie Cash
fcash at ocis.net
Tue Sep 19 15:53:58 PDT 2006
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
You can probably even remove the cat and just use awk on the file
directly.
----
Freddie Cash
fcash at ocis.net
More information about the freebsd-stable
mailing list