Where condition in grep or awk?

yadavricky · #1 02-15-2013

Dear All,

I need help..

I am having a csv file.

Code:

Home_TITLE,People_TITLE,Repo_ALIAS
HMN5530,RKY5807,/mine_repo/rike001
HMN5530,SRY6443,/mine_repo/rike001
HMN5530,ARDY001,/mine_repo/rike001

Franklin52 · #2 02-15-2013

Try something like this:

Code:

var1="RKY5807"
var2="HMN55303"

new_var=$(awk -F"," -v v1="$var1" -v v2="$var2" '$1==v1 && $2==v2{print $3}')

yadavricky · #3 02-15-2013

Its not working Please let me know if you have some other option.

---------- Post updated at 10:56 AM ---------- Previous update was at 10:47 AM ----------

Code:

awk -F "," '/AVE5530/&&/EFC6145/ {print $3}' WiseReference.csv

panyam · #4 02-15-2013

Try this:

Code:

awk -F ","  -v var1="AVE5530" -v var2="EFC6145"  '/var1/&&/var2/ {print $3}' WiseReference.csv

yadavricky · #5 02-15-2013

No its not working can you please check i am getting the blank value

Corona688 · #6 02-15-2013

Quote:

Originally Posted by yadavricky

If i give value directly then it is working fine

awk -F "," '/$var1/&&/$var2/ {print $3}' WiseReference.csv

it is not giving any output

please help

Shell variables do not expand in single quotes, never have.

panyam's suggestion has a small mistake in it. Try this:

Code:

awk -F ","  -v var1="AVE5530" -v var2="EFC6145"  '(var1 ~ $0) &&(var2 ~ $0) {print $3}' WiseReference.csv

Yoda · #7 02-15-2013

Quote:

Originally Posted by yadavricky

No its not working can you please check i am getting the blank value

Note that this is an AND && condition, so both condition should satisfy. Make sure you have these values in 1st and 2nd field.

Try this:

Code:

awk -F, -v var1="HMN5530" -v var2="RKY5807"  '$1==var1&&$2==var2{print $3}' WiseReference.csv

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
grep not equal to condition	prash358	Shell Programming and Scripting	6	08-22-2012 05:26 PM
HELP with AWK one-liner. Need to employ an If condition inside AWK to check for array variable ?	shell_boy23	Shell Programming and Scripting	6	07-10-2012 05:20 AM
grep in the if condition	boopal	Shell Programming and Scripting	8	12-09-2011 11:17 AM
use awk pick value from lines as condition for grep	jackoverflow	Shell Programming and Scripting	2	06-24-2010 06:37 PM
grep command with AND condition	prasperl	Shell Programming and Scripting	6	01-26-2010 03:54 AM

The Following User Says Thank You to Franklin52 For This Useful Post:
yadavricky (02-15-2013)