Awk tricks

awk_useful_commands

## summary.csv and input_postconnect.csv are dummy files of example.

# Filter examples
## print entire row
awk -F';' '{ if( ($3=="") && (($5~"human")||($5~"machine"))) { print } }' summary.csv
awk -F';' '{ if( ($3~"human") && ($5!~"human") && ($5!="")) { print } }' summary.csv

## print specific column $1
awk -F';' '{ if( ($3~"human") && ($5!~"human") && ($5!="")) { print $1 } }' summary.csv


# Create new column based on ifelse statement
 awk -F';' '{ print $4,$2}' OFS=';'  input_postconnect.csv | awk -F';' '{ if($2 ~ "human") $(NF+1)="human"; else $(NF+1)="nohuman"; print}' OFS=';'