AWK pattern matching

Shell Programming and Scripting
1

Hi,

How can I tell awk to print all lines/columns if column number 5 contains the word Monday?

I have tried

nawk -F, '$5==Monday' OFS=, myfile > outputfile

but that doesn't work (I am a newb!!)

Thanks,

2

use :

awk -F, '{$5==Monday}1' OFS=, file
3 
awk -F, '{$5==Monday}1' OFS=, file > newfile

Doesn't seem to work. newfile just contains the same contents as file

Thanks,

4

Post ur source file please

5

Source File:

mr,bob,bobson,Monday,20,france
mrs,caroline,godsom,Monday,30,Germany
mrs,sarah,bishop,Wednesday,10,UK
mr,karl,jacobs,Thursday,29,spain
mr,trevor,duell,Monday,34,belgium
miss,kate,dartsen,Wednesday,76,Austria

Thanks,

6

Wrong field and lack of double quotes:

nawk -F, '$4=="Monday"' OFS=, myfile > outputfile
7 
 grep -E "(.[^,]*),(.[^,]*),(.[^,]*),[ \t]*Monday[ \t]*" file
8

Post deleted