selecting into a new file

[meghardy]

Hi there,

I am new to AWK and trying to do the following without success! If you can help, that would be great!

I have a file from which i want to extract into a new file, all the lines which have an N in the second column. The file is delimited by "|".

Any ideas?

Thanks
Meg

 

[Ygor]

Is this a homework assignment?

 

[meghardy]

No! I am 25 years old! Its a problem with client data which i am trying to sort out. A suggestion was made to use awk, unfortunately, i've only used it a little. Do you have any suggestions on how to do this?

Thanks again
Meg

 

[Ygor]

Sure...
[tt]
awk -F\| '$2=="N" {print $0}' file1 > file2
[/tt]

 

[meghardy]

It worked a treat! Thanks for that!

Meg