I would like to add a new column in a text file which contains values based on the value of another column.
suppose the text file contains:
1 abc 67
2 def 40
3 uty 57
Now i would like to add a new column which contains value 'yes' if the column 3 > 40 else 'no'.
Is it possible using awk ??