From owner-freebsd-questions@FreeBSD.ORG  Fri Oct 30 08:05:23 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 1106A106566C
	for <freebsd-questions@freebsd.org>;
	Fri, 30 Oct 2009 08:05:23 +0000 (UTC)
	(envelope-from j.mckeown@ru.ac.za)
Received: from c.mail.ru.ac.za (c.mail.ru.ac.za [IPv6:2001:4200:1010::25:3])
	by mx1.freebsd.org (Postfix) with ESMTP id B0FE78FC1A
	for <freebsd-questions@freebsd.org>;
	Fri, 30 Oct 2009 08:05:20 +0000 (UTC)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=ru-msa; d=ru.ac.za;
	h=Received:From:Organization:To:Subject:Date:User-Agent:References:In-Reply-To:X-Face:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id:X-Virus-Scanned:X-Authenticated-User;
	b=cJl2fyvr1Az5NOmm4WQJZpAxNn06qLzE9+kkr4IqGT4jNBucrcsOkZRPWTwcmrpv7C+OD35ctf+vZXcLxm9Spx3sZIxz92cp7/84phnlOPJ4zpvUzJ1MXtM446JnMEEQ;
Received: from vorkosigan.ru.ac.za
	([2001:4200:1010:1058:219:d1ff:fe9f:a932]:65214)
	by c.mail.ru.ac.za with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69 (FreeBSD)) (envelope-from <j.mckeown@ru.ac.za>)
	id 1N3mU2-000Irk-Nh
	for freebsd-questions@freebsd.org; Fri, 30 Oct 2009 10:05:18 +0200
From: Jonathan McKeown <j.mckeown@ru.ac.za>
Organization: Rhodes University
To: freebsd-questions@freebsd.org
Date: Fri, 30 Oct 2009 10:05:18 +0200
User-Agent: KMail/1.9.10
References: <200910291844.n9TIiC5v037167@dc.cis.okstate.edu>
In-Reply-To: <200910291844.n9TIiC5v037167@dc.cis.okstate.edu>
X-Face: $@VrUx^RHy/}yu]jKf/<4T%/d|F+$j-Ol2"2J$q+%OK1]&/G_S9(=?utf-8?q?HkaQ*=60!=3FYOK=3FY!=27M=60C=0A=09aP=5C9nVPF8Q=7DCilHH8l=3B=7E!4?=
	=?utf-8?q?2HK6=273lg4J=7Daz?=@1Dqqh:J]M^"YPn*2IWrZON$1+G?oX3@
	=?utf-8?q?k=230=0A=0954XDRg=3DYn=5FF-etwot4U=24b?=<FO&kjQCGnjz>dTS{i<i?:=p!]'t#K~4)cr7o%ygQiso
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200910301005.18537.j.mckeown@ru.ac.za>
X-Virus-Scanned: c.mail.ru.ac.za (2001:4200:1010::25:3)
X-Authenticated-User: s0900137 from vorkosigan.ru.ac.za
	(2001:4200:1010:1058:219:d1ff:fe9f:a932) using auth_plaintext
Subject: Re: Merging Related Information from 2 Tables
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 30 Oct 2009 08:05:23 -0000

On Thursday 29 October 2009 20:44:12 Martin McCormick wrote:
> Giorgos Keramidas writes:
> > You should use a Perl or Python script, and a hash...
> >
> > If you show us a few sample lines from the input file and how you want
> > the output to look, it shouldn't be too hard to quickly hack one of those
> > together.

The alternative is to use join(1).

> 	A records look like:
>
> hydrogen.cis.osu. 43200	IN	A	192.168.2.123
>
> Text or TXT records look similar [...]
>
> hydrogen.cis.osu. 5	IN	TXT	"cordell-north,009,192.168.2.123"

This will work well since the default join field is the first field in the 
line.

Jonathan