From owner-freebsd-questions@FreeBSD.ORG  Thu Oct 29 18:44:20 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 A3E95106566C
	for <freebsd-questions@freebsd.org>;
	Thu, 29 Oct 2009 18:44:20 +0000 (UTC)
	(envelope-from martin@dc.cis.okstate.edu)
Received: from dc.cis.okstate.edu (dc.cis.okstate.edu [139.78.103.93])
	by mx1.freebsd.org (Postfix) with ESMTP id 7AD5B8FC0C
	for <freebsd-questions@freebsd.org>;
	Thu, 29 Oct 2009 18:44:20 +0000 (UTC)
Received: from dc.cis.okstate.edu (localhost.cis.okstate.edu [127.0.0.1])
	by dc.cis.okstate.edu (8.14.2/8.13.8) with ESMTP id n9TIiC5v037167
	for <freebsd-questions@freebsd.org>;
	Thu, 29 Oct 2009 13:44:12 -0500 (CDT)
	(envelope-from martin@dc.cis.okstate.edu)
Message-Id: <200910291844.n9TIiC5v037167@dc.cis.okstate.edu>
To: freebsd-questions@freebsd.org
Date: Thu, 29 Oct 2009 13:44:12 -0500
From: Martin McCormick <martin@dc.cis.okstate.edu>
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: Thu, 29 Oct 2009 18:44:20 -0000

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.

	Perl and python-- I wasn't even thinking of that! Thank
you. I have installed python now on the FreeBSD system and will
start learning it.

	A records look like:

hydrogen.cis.osu. 43200	IN	A	192.168.2.123

Text or TXT records look similar except that the data they
convey are ASCII text strings of various information that are
either read by people or maybe tell servers how to behave toward
that particular client.

hydrogen.cis.osu. 5	IN	TXT	"cordell-north,009,192.168.2.123"

Our hope is to have an output line looking like:

192.168.2.123 hydrogen.cis.osu "cordell-north,009,192.168.2.123"

	We will actually run that output through sed to convert
the "'s to blanks and also the ,'s to blanks but that is
trivial.

Thanks for the examples.

Martin McCormick