Shell Programming and Scripting

Hello!
So ive been presented with this comma-delimited file:
I need a print to look as below
"
lastname, phone_number, zip

for every person with a last name starting with the letter H, I

only with a 650-area code phone number. output should be sorted by reverse ZIP code "

I only have four columns

Harris, K, (650)345-1760 1200, Ellis Street Suite 230 Mountain CA 93042
Mitchell, A, (212)-555-1234 650, This Street NY NY 01234
Thomson, F, (650)-999-9999 1450, The Terrace Avenue Stratford MA 10101
irvin, h, (650)678-2445 12345, denver st santa clara 96503


I thought I was on the right path with this code:

Code:

cat data.csv | awk -F"," '{print $1, $2, $3, $4}' |sort -t ',' -k1|grep "(650)"

then to try to grep just the last name's first letter only...

Code:

cat data.csv | awk -F "," '$1~/"H*"/' '{print $1, $2, $3, $4}'

but keep getting errors.
How can I search for just the first letter as well as only part of a string in the last column and reverse order that?(I imagine with sort?)

Assuming you want records starting with h and i and contains zip code of 650

try

Code:

grep -i -E "^h|^i" data.csv | grep "(650)"

It returns zero results, if i use just that syntax or append it to mine.

What you are trying..?

Code:

$ cat file
Harris, K, (650)345-1760 1200, Ellis Street Suite 230 Mountain CA 93042
Mitchell, A, (212)-555-1234 650, This Street NY NY 01234
Thomson, F, (650)-999-9999 1450, The Terrace Avenue Stratford MA 10101
irvin, h, (650)678-2445 12345, denver st santa clara 96503

$ grep -i -E "^h|^i" file | grep "(650)"
Harris, K, (650)345-1760 1200, Ellis Street Suite 230 Mountain CA 93042
irvin, h, (650)678-2445 12345, denver st santa clara 96503

I believe that the following command does what was requested:

Code:

awk '/^[HhIi]/{printf("%s,%s\n", $NF, $0)}' input|sort -rn|awk 'BEGIN{FS=OFS=","}$4~/(650)/{print $2, $4, $1}'

The first awk selects last names starting with H or I (case insensitive) and adds a new 1st field just containing the ZIP code. The sort performs a reverse order sort on the ZIP code. The second awk selects phone numbers in area code 650 and prints just the last name, phone, and zip code in the desired order. For the given input, the result is:

Code:

irvin, (650)678-2445 12345,96503
Harris, (650)345-1760 1200,93042

with single awk... and sort

Code:

$awk -F, '/^[HhIi]/ && $3 ~ /(650)/{n=split($NF,P," ");print $1,$3,P[n]}' OFS="," file | sort -t, -nrk3

irvin, (650)678-2445 12345,96503
Harris, (650)345-1760 1200,93042