Date: Sun, 2 Nov 2008 14:37:53 +1000 From: Gary Newcombe <gary@pattersonsoftware.com> To: freebsd-questions@freebsd.org Subject: Re: OT: Shell Script using Awk Message-ID: <20081102143753.d1f66ad9.gary@pattersonsoftware.com> In-Reply-To: <2daa8b4e0811011821q210ae3a5j8f612a0fc79e8844@mail.gmail.com> References: <2daa8b4e0811011821q210ae3a5j8f612a0fc79e8844@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, 1 Nov 2008 18:21:55 -0700, "David Allen" <the.real.david.allen@gmail.com> wrote:
> My apologies for asking on this list, but I'm stuck without Perl and need
> to use awk to generate a report.
>
> I'm working with a large data set spread across multiple files, but to
> keep things simple, say I have A Very Long String that containing records,
> each delimited by a single space. I need to print those records in
> columnar format, but with only 7 columns per line:
>
> record1 record2 record3 record4 record5 record6 record7
> record08 record09 record10 record11 record12 record13 record14
> ...
>
> Should be simple, but I'm getting nowhere.
Is this what you're after?
$ cat input
col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 ....
cat input | awk -F\ '{for (i=1;i<NF;i+=7) print $i,$(i+1),$(i+2),$(i+3),$(i+4),$(i+5),$(i+6) }'
>
> Thanks!
>
> --
> David "promising never to do this again" Allen
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20081102143753.d1f66ad9.gary>