Date: Mon, 14 May 2001 11:15:47 +0000 From: Hug Me <hugme@hugme.org> To: Tom ONeil <tom.oneil@tacni.com> Cc: freebsd-isp@FreeBSD.org Subject: Re: sed question - phone list Message-ID: <20010514111547.A30769@pitr.tuxinternet.com> In-Reply-To: <3AFFE1CC.E89BA8D7@tacni.com>; from tom.oneil@tacni.com on Mon, May 14, 2001 at 08:46:52AM -0500 References: <3AFFE1CC.E89BA8D7@tacni.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, May 14, 2001 at 08:46:52AM -0500, Tom ONeil wrote:
>
>
> Greetings All;
>
> I have a script that handles our pop numbers and it requires I change
> the format of a large poplist we use for input.
>
> This is the format - CA,Anaheim,714,408,4411
> and what I need is - CA,Anaheim,714-408-4411
> because I don't enough perl to modify the script and I can't figure out
> how use sed to do it.
>
> awk will do the substitution, but removes the first 2 commas in the
> process.
> awk -F, '{print $1,$2,$3,-$4,-$5}' poplist
you are missing some prans:
awk -F, '{ print $1","$2","$3"-"$4"-"$5 }'
this should work, I would not suggest sed. unless you need to search
for that string within the document.
hugme
http://www.hugme.org
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-isp" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20010514111547.A30769>