From owner-freebsd-questions@FreeBSD.ORG  Thu Aug 21 13:00:48 2008
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 F15B51065680
	for <freebsd-questions@freebsd.org>;
	Thu, 21 Aug 2008 13:00:48 +0000 (UTC)
	(envelope-from steve@ibctech.ca)
Received: from ibctech.ca (v6.ibctech.ca [IPv6:2607:f118::b6])
	by mx1.freebsd.org (Postfix) with SMTP id 768ED8FC1D
	for <freebsd-questions@freebsd.org>;
	Thu, 21 Aug 2008 13:00:48 +0000 (UTC)
	(envelope-from steve@ibctech.ca)
Received: (qmail 13781 invoked by uid 89); 21 Aug 2008 13:08:18 -0000
Received: from unknown (HELO ?IPv6:2607:f118::5?)
	(steve@ibctech.ca@2607:f118::5)
	by 2607:f118::b6 with ESMTPA; 21 Aug 2008 13:08:18 -0000
Message-ID: <48AD6759.5030506@ibctech.ca>
Date: Thu, 21 Aug 2008 09:02:17 -0400
From: Steve Bertrand <steve@ibctech.ca>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: Joseph Olatt <joji@eskimo.com>
References: <48AD63B7.8090107@ibctech.ca> <20080821055429.A26910@eskimo.com>
In-Reply-To: <20080821055429.A26910@eskimo.com>
X-Enigmail-Version: 0.95.6
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: sed/awk, instead of Perl
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, 21 Aug 2008 13:00:49 -0000

Joseph Olatt wrote:

> Try the following:
> 
> 
>  cat t.txt | awk -F\t '{split($1, arr, "."); printf("%s_%s@%s\n", arr[
> 1], arr[2], $2);}'
> 
> where t.txt:
> john.doe    example.com

This did the job, the only modification I needed to make was manually 
replace $2 with the string of the domain I needed it changed to.

Fantastic!

Thanks everyone for such quick responses!

Steve