UNIX for Dummies Questions & Answers

hi all,

I am having trouble finding the right string for this - I dont know whether to use awk or sed..

If I have a file with alot of names and phone numbers like this

Code:

McGowan,Sean  978-934-4000
 Kilcoyne,Kathleen 603-555-1212
 Club603,The 617-505-1332
 Boyle,William 301-444-1221

And I want to print just the line with the 603 area code plus remove all area codes int he final output sorted alpha by last name - how would I do it?

would I need to define a character set?

Moderator's Comments:

Please use code tags when posting data and code samples!

Code:

nawk '$2~/^603-/{$2=substr($2,5);print}' myFile |sort

is there a way to do this using sed?

Code:

sed -e 's/ [0-9]*-/ /' myFile

---------- Post updated at 10:43 PM ---------- Previous update was at 10:41 PM ----------

Oooops : no need for the -e :

Code:

sed 's/ [0-9]*-/ /' infile

Code:

sed -n '/ 603-/s/ 603-/ /p' myFile | sort

This works except that the column with the area code is $3 not $2 so when I substituted $2 for $3 - the command works !!
Trying to understand this tho...I know $3=substr means substitution in column 3 but where did the 5 come from? please explain?

Ooops yep i forgot that 603 ...
similar one

Code:

sed '/ 603-/!d;s/ 603-/ /' infile | sort