I have a CSV file with values like the following:col1,col2,col3,col4,col5,col6,col71,0,0,0,0,BTS,Active4,5,3,1,1,LocalMode,Offlne1,2,5,6,3,PermFault,Offline1,2,6,6,2,BSC,Active7,8,2,3,2,NE,Offline1,7,6,5,2,BSC,ActiveI want to fetch the values rows from this CSV file in such a way that the following sample conditions are met:1)  if (col7=Active )    then         sum of col1 values from all the rows2) if (col6 == somevalue && column5 != somevalues)then      sum of col1 values from all the rows.I am able to fetch the rows from CSV file based on one column values which meets my first condition with the following awk command:awk -F, '$7 == Active { print }' test.csvHow can i use multiple conditions in this awk command which checks multiple column values as mentioned in above sample condition 2 where i need to check present of some specific text in col6 and at the same time i need to ignore some keywords from column5. Is there a better and easier way of doing this instead of awk?
How to select rows from a CSV file based on different column values?
shell script;awk;csv