mask ID number

lyoncc · #1 (**permalink**) 07-20-2007

HP-UX 11i v2. #!/bin/sh

Hi all.

I have a flat file like this with lines like this:

|07/19/07|08:26AM|1|CupsCoffee|CupsCo|989898989 |Doe, John Y |THE PLUS CARD - Price| | |Y| | 2.00|

I would like to replace the id number (field 6) with a masked version, ie *****8989. Everything else stays the same. The field is always 9 characters. I was thinking about sed or maybe tr.

Thanks in advance!!!!

Perderabo · #2 (**permalink**) 07-20-2007

Try:
awk -v 'FS=|' -v 'OFS=|' '{ $7="*****"substr($7,6,4) ; print $0 }' data

lyoncc · #3 (**permalink**) 07-20-2007

Perderabo,

Perfect!

Thanks!!!!!

Shell_Life · #4 (**permalink**) 07-20-2007

Based on your data sample:

Code:

sed 's/|...../|*****/5' input_file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to Mask ur MAC address in BSD	PenguinDevil	BSD	1	06-12-2004 10:43 PM
How do I mask my MAC address	PenguinDevil	IP Networking	2	04-26-2004 02:26 PM
Changing the mask	kkinnon	IP Networking	1	04-02-2003 12:05 PM
password mask in C	krishna	High Level Programming	5	06-18-2002 08:31 AM
Subnet mask	Z0DiaC	IP Networking	7	09-15-2001 07:09 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by