From owner-freebsd-questions@FreeBSD.ORG Sun Nov 2 04:31:21 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 019A1106564A for ; Sun, 2 Nov 2008 04:31:21 +0000 (UTC) (envelope-from jdc@koitsu.dyndns.org) Received: from QMTA08.westchester.pa.mail.comcast.net (qmta08.westchester.pa.mail.comcast.net [76.96.62.80]) by mx1.freebsd.org (Postfix) with ESMTP id A03C68FC14 for ; Sun, 2 Nov 2008 04:31:20 +0000 (UTC) (envelope-from jdc@koitsu.dyndns.org) Received: from OMTA10.westchester.pa.mail.comcast.net ([76.96.62.28]) by QMTA08.westchester.pa.mail.comcast.net with comcast id a3Ce1a0050cZkys584WwzP; Sun, 02 Nov 2008 04:30:56 +0000 Received: from koitsu.dyndns.org ([69.181.141.110]) by OMTA10.westchester.pa.mail.comcast.net with comcast id a4XK1a0062P6wsM3W4XKJJ; Sun, 02 Nov 2008 04:31:19 +0000 X-Authority-Analysis: v=1.0 c=1 a=QycZ5dHgAAAA:8 a=u0kkRlp3z57mkRhdK70A:9 a=PrBWAYca28jGtBb1_VkIjJgB3-wA:4 a=EoioJ0NPDVgA:10 a=SV7veod9ZcQA:10 a=LY0hPdMaydYA:10 Received: by icarus.home.lan (Postfix, from userid 1000) id ACAD0C9419; Sat, 1 Nov 2008 21:31:18 -0700 (PDT) Date: Sat, 1 Nov 2008 21:31:18 -0700 From: Jeremy Chadwick To: David Allen Message-ID: <20081102043118.GA83340@icarus.home.lan> References: <2daa8b4e0811011821q210ae3a5j8f612a0fc79e8844@mail.gmail.com> <20081102020344.GA80530@icarus.home.lan> <2daa8b4e0811012117i5d3f30d3w9ea927679cb5e7b1@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2daa8b4e0811012117i5d3f30d3w9ea927679cb5e7b1@mail.gmail.com> User-Agent: Mutt/1.5.18 (2008-05-17) Cc: freebsd-questions@freebsd.org Subject: Re: OT: Shell Script using Awk X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 02 Nov 2008 04:31:21 -0000 On Sat, Nov 01, 2008 at 08:17:54PM -0800, David Allen wrote: > On 11/1/08, Jeremy Chadwick wrote: > > On Sat, Nov 01, 2008 at 06:21:55PM -0700, David Allen 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. > > > > $ cat input > > col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 > > > > $ cat output.awk > > { > > print $1 " " $2 " " $3 " " $4 " " $5 " " $6 " " $7 > > print $8 " " $9 " " $10 " " $11 " " $12 " " $13 " " $14 > > } > > > > $ cat intput | awk -f output.awk > > col1 col2 col3 col4 col5 col6 col7 > > col8 col9 col10 col11 col12 col13 col14 > > Thanks for the reply, Jeremy, but that approach would require an > entirely manual approach, which isn't suitable for what I'm working > with. Writing a script that's the same size as the data I'm working > with isn't an option. ;-) I'm confused -- what's the problem? -- | Jeremy Chadwick jdc at parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. PGP: 4BD6C0CB |