How can I use multiple if statement inside another if statement of a awk program?

Question

I have a CSV File and I want to have multiple checks to retrieve the data from the CSV file. I have the following conditions which needs to be taken care of and I am trying to use awk in a shell script to fulfill these conditions:

if ( ColD == "TRX" || ColD == "TX" )
{
   if (ColJ == "BTS INT UNAFF" || ColJ == "LOCAL MODE")
   {
      if (ColL !="OPER" && ColL != "") #Second Value shouldn't be blank
      {
         if (ColU != "2000")
         {
             if (ColA != "*_*") # Should not contain _ in the value.
             then
                   print all the resulting filtered columns of this csv file

Here ColA, ColB etc. are the column numbers which i use as $1, $2 and so on.

Now I know simple awk usage of a single if condition is something like this:

awk -F, '{
                if ($23 == "TOP36")
                print $11
            }' $INPUT_PATH/$fileName

and could find the nested if conditions something like this:

awk '
{if ( $6 == 0 && $8 > 0 && $8 <= 9 ) { $6 = "left" } else {
  if ( $8 == 0 && $6 > 0 && $6 <= 15 ) { $6 = "bottom" } else {
    if ( $8 == 9 && $6 > 0 && $6 <= 15 { $6 = "top" } else {
      if ( $6 == 15 && $8 > 0 && $8 <= 9 { $6 = "right" }
      }
    }
  }
} {print}'

But, I think my conditions can be satisfied if I put satisfy one if condition on top and then next under it and so on. How can I do it using awk if statements? Is there a better way to do this?

Peter.O · Accepted Answer · 2015-07-16 04:32:28Z

5

Nested if statements are effectively statement and statement, so if you do not need to do any particular processing as you step through the nesting, then you can just join them all up with &&.

  awk '{ if( ( $4 == "TRX" || $4 == "TX" ) &&
             ( $10 == "BTS INT UNAFF" || $10 == "LOCAL MODE" ) && 
             ( $12 != "OPER" && $12 != "" ) && # Second Value should not be blank
             ( $22 != "2000") &&
             ( !match( $1, "_") ) ) # Should not contain _ in the value.
           { print } 
       }' FS=, file

To define your Field Separator, you can use option -F, instead of parameter FS=, if you prefer – or have it fully contained within the awk code, in the BEGIN{ } pre-file-processing block: BEGIN{ FS="," }

edited Jul 16, 2015 at 4:32

answered Jul 15, 2015 at 18:10

Peter.O

33.8k32 gold badges120 silver badges167 bronze badges

And if the only action is print, then you can use just awk FS=, '($4 == "TRX" || $4 == "TX") && … && !match($1, "_")'

Gilles 'SO- stop being evil'
– Gilles 'SO- stop being evil'

2015-07-15 23:02:33 +00:00
Commented Jul 15, 2015 at 23:02
Thanks a lot Gary and Gilles for your inputs. I will try this. One more question here, in the last condition, (!match $1, "-") Is this going to ignore all the values in column 1 where value conatins a _ ex: BTS_101, BSC_505 etc? and the hopefully the last print statement prints the entire CSV file data after filtering all the above conditions in the input CSV file?

Ankit Vashistha
– Ankit Vashistha

2015-07-16 04:36:06 +00:00
Commented Jul 16, 2015 at 4:36

Add a comment |

Stack Exchange Network

How can I use multiple if statement inside another if statement of a awk program?

1 Answer 1

You must log in to answer this question.

Hot Network Questions

How can I use multiple if statement inside another if statement of a awk program?

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions