I need only those records which has $2 equal to "DEF" independent of case (i.e upper or lower)
nawk -F"," '$2 ~ /[Dd][Ee][Ff]/{print $0}' file
This returns 3rd record also which i dont want
I tried this but this doesnt work as expected.
nawk -F"," '$2 == "[Dd][Ee][Ff]"{print $0}' file
i dont need the following record.
abc,kDEF
Help is appreciated.