Multiple match 1

[Calz]

Can anyone help, bit of a noob to awk so strugling here

This is a netbackup command that produces an output with many fields, we ignore the first 3 lines, I'm trying to ignore field $12 of "ABC" "DEF" "GHI" and produce a count but in the case of DEF I also need to ignore anything that starts with A on $1 so need $1 !~/A/ but not sure how to combine them together, if I just add $1 !~/A/ in it excludes everything that starts with A

vmquery -w -a |awk 'NR>3 && $12!="ABC" && $12!="DEF" && $12!="GHI" {n++}; END {print n+0}'

 

[feherke]

Hi

if I just add $1 !~/A/ in it excludes everything that starts with A

No. That would ignore those containing A in the 1[sup]st[/sup] field.

Field 1 not starts with A has to be written as [tt]$1!~/[red]^[/red]A/[/tt] .


Feherke.

http://rootshell.be/~feherke/

 

[Calz]

Thanks, it achieves the same result in my file but doesn't solve the initial problem.

 

[feherke]

Hi

Maybe if you post a sample input and desired output... I do not understand what you want exactly.


Feherke.

http://rootshell.be/~feherke/

 

[Annihilannic]

Perhaps:

vmquery -w -a |awk 'NR>3 && $12!="ABC" && !($12=="DEF" && $1 =~ /^A) && $12!="GHI" {n++}; END {print n+0}'

Or personally I find it easier not having lots of nots (it ties me in knots) :

vmquery -w -a |awk 'NR>3 && !($12=="ABC" || ($12=="DEF" && $1 =~ /^A) || $12=="GHI") {n++}; END {print n+0}'

Annihilannic.

 

[Calz]

Thanks but with both od those I get...

awk: syntax error near line 1
awk: bailing out near line 1

 

[Annihilannic]

Sorry, some typos... change =~ to just ~ (I've been writing too much perl lately), and terminate my regexp's with another /.

Annihilannic.

 

[Calz]

I had to tweak it a bit for what I wanted ultimately but all working, thanks )