printing lines where certain columns do not match, with awk

awk matching
user2232814 picture user2232814 · Apr 26, 2013 · Viewed 14.3k times · Source

I have a tab separated file like this:

1       10502   C       T  
1       10506   C       T  
1       10567   G       A 
...

And I'm trying to print out all lines where column 3 != column 4, excluding the cases where column 3 = C and column 4 = T.

I tried

awk '{
if (($3 == $4) || ($3 == C && $4 == T) )
        next ;
else
        print $0; }'

but I'm not sure what's going wrong...

Answer

Kent picture Kent · Apr 26, 2013

just fix your codes:

awk '($3 != $4) && !($3=="C" && $4=="T")' file

Related questions

How can I use ":" as an AWK field separator?

Given the following command, echo "1: " | awk '/1/ -F ":" {print $1}' why does AWK output: 1: ?

Read More
How to do a recursive find/replace of a string with awk or sed?

How do I find and replace every occurrence of: subdomainA.example.com with subdomainB.example.com in every text file under the /home/www/ directory tree recursively?

Read More
How do I use shell variables in an awk script?

I found some ways to pass external shell variables to an awk script, but I'm confused about ' and ". First, I tried with a shell script: $ v=123test $ echo $v 123test $ echo "$v" 123test Then tried awk: $ awk 'BEGIN{print "…

Read More