Shell Programming and Scripting

Hello,
I want to read a CSV file and look for a pattern on each line. If the pattern is found I want to read another portion/column of that line and print that. Can somebody help me in writing it in CSH?

E.g. CSV file has following lines,

Code:

1,Elephant,500kg,,,,,
2,Tiger,50kg,,,,,
3,Rabbit,1kg,Left,,,,
4,Lion ,50kg,,,,,
5,Hippo,500kg,,,,,

Then if I pass 500kg, to script I should get "Elephant" and "Hippo" printed at output. When I pass 1kg to script I should get "Rabbit" printed at output.

Moderator's Comments:

Please use code tags next time for your code and data.

Code:

grep 500kg infile.csv| cut -d"," -f2

Sounds like a job for awk.

Code:

awk -F, '$3 == "500kg" { print $2; }'

-F, sets the field separator as comma. $2 and $3 refer to the fields. If you want to put it in a script and pass a shell variable into the awk code, you use -v "awkvar=$shellvar", for example.

Code:

awk -F, -v "weight=$weight" '$3 == weight { print $2; }'

awk variables aren't generally preceded with $ like in shell except for getting the strings inside of a field

Thanks.

---------- Post updated at 03:06 PM ---------- Previous update was at 02:17 PM ----------

They should be on separate lines.

If it doesn't fit, please explain what you mean -- show the output you want in code tags.

You can put program output into a variable with backticks.