Shell Programming and Scripting

I have a text file with lot of rows like..
Action & Adventure|2012: Supernova NR|2009-11-01 00:01:00|2010-05-01 23:59:00|Active|3
Action & Adventure|50 Dead Men Walking|2010-01-05 00:01:00|2010-06-30 23:59:00|Active|3
Action & Adventure|Afterwards|2009-11-26 00:01:00|2010-03-26 23:59:00|Deactivated|3

the 5th column can have different statuses.i want to extract all the rows from the file having only "Active" in the 5th column.
pls.help.

Thanks in advance.

Code:

awk -F '|' '$5 ~ /^Active$/ {print $0}' filename

May be I should do some explaining too

awk is a unix filter.
-F : field separator, in your case its the character '|'
the awk script says that if the $5 (5th field) ~ (matches) the pattern /^Active$/ (^ and $ mean begins with and ends with respectively), then print $0, i.e the entire line.

Lemme know if that helped.

Thanks for the reply.

i tried like this but a.txt is empty

Code:

 
awk -F"|" '$5 ~ /^Active$/ {print $0}' FinalVHO.txt>a.txt

is there anything wrong with it?

well i copied the text from your post verbatim and ran the same line of code I provided and it worked. How big is your input file? Are there spaces/tabs around the word Active in the 5th column? Is there atleast one line in the file that has Active in the 5th column?