From owner-freebsd-questions@FreeBSD.ORG Sun Nov 2 04:50:39 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 660821065680 for ; Sun, 2 Nov 2008 04:50:39 +0000 (UTC) (envelope-from gary@pattersonsoftware.com) Received: from mail.pattersonsoftware.com (mail.pattersonsoftware.com [121.52.192.10]) by mx1.freebsd.org (Postfix) with ESMTP id 216B08FC0A for ; Sun, 2 Nov 2008 04:50:39 +0000 (UTC) (envelope-from gary@pattersonsoftware.com) Received: from localhost (mail [127.0.0.3]) by mail.pattersonsoftware.com (Postfix) with ESMTP id 0D5514B7B32; Sun, 2 Nov 2008 14:50:38 +1000 (EST) X-Virus-Scanned: amavisd-new at pattersonsoftware.com Received: from mail.pattersonsoftware.com ([127.0.0.3]) by localhost (mail.pattersonsoftware.com [127.0.0.3]) (amavisd-new, port 10024) with ESMTP id CCJMWpPt07vJ; Sun, 2 Nov 2008 14:50:33 +1000 (EST) Received: from elegia (60-242-254-180.static.tpgi.com.au [60.242.254.180]) by mail.pattersonsoftware.com (Postfix) with ESMTPSA id E17344B7B18; Sun, 2 Nov 2008 14:50:32 +1000 (EST) Date: Sun, 2 Nov 2008 14:50:31 +1000 From: Gary Newcombe To: "David Allen" Message-Id: <20081102145031.7d4e50aa.gary@pattersonsoftware.com> In-Reply-To: <2daa8b4e0811012117i5d3f30d3w9ea927679cb5e7b1@mail.gmail.com> References: <2daa8b4e0811011821q210ae3a5j8f612a0fc79e8844@mail.gmail.com> <20081102020344.GA80530@icarus.home.lan> <2daa8b4e0811012117i5d3f30d3w9ea927679cb5e7b1@mail.gmail.com> Organization: Patterson Software X-Mailer: Sylpheed 2.5.0rc2 (GTK+ 2.12.12; x86_64-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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:50:39 -0000 On Sat, 1 Nov 2008 20:17:54 -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 > Maybe you want them to line up too. Would using tabs be appropriate? Maybe something like this? awk -F\ '{for (i=1;i 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. ;-) > _______________________________________________ > 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"