Shell Programming and Scripting

Hi Folks,

I have a file with 22 columns. In which, I need to remove nulls if found at $2, $4, $14 & $16. Then, needs to compare the fields such as $2 == $14 && $4 == $16. The final output will print all the fields where the above conditions are satisfied.

Could you please anyone help me with AWK script? Basically, I am a one-line AWK,sed programmer; finding difficult to resolve.

Thank you.

Welcome to the form.

Seems you know awk. Why not just try to write more than one liner.
You have already written most of the part of your condition. Its simple.

Hi Anchal,

Thanks for your care on my learning curve..

I tried last two days and finally decided that some one needs to guide me on reading record levels such as NF,NR & etc., It would be grateful if anyone SME's just guide me how to proceed further, it would really helpful to finish my current assignment.

Thank you.

Can you post the sample data (input and output)?

Input
a b c d e f g
1 2 3 1 5 6 2
. 3 4 5 8 9 3

Output:
Since a have null that line needs to be removed.
And, a=d and b=g
it should print the first line in the output
1 2 3 1 5 6 2

Based on the conditions and the sample data you have shown,

Code:

$ cat f7
a b c d e f g h
1 2 3 4 5 6 2 4
. 9 10 11 12 13 14 15
$ 
$ 
$ awk '$2 != "." && $4 != "." && $7 != "." && $8 != "." && $2 == $7 && $4 == $8 {print}' f7
1 2 3 4 5 6 2 4
$

I have modified the data a bit to meet the conditions.
Please note $7 is equivalent to $14 and $8 is equivalent to $16 from your original post.

Hi Rachel,

Thank you so much.

Works Perfect.

Regards,
Jerald Nathan.