I'm looking for a script which given the following input:

A=0 B=0 C=0

A=0 B=0 C=0

A=0 B=0 C=0

A=0 B=0 C=0.01

A=0 B=0 C=0

A=0 B=0 C=2

would output all the lines where the field "C" is not zero, that is:

A=0 B=0 C=2

A=0 B=0 C=0.01

One way to do it is grep "C=1" | "C=2" | "C=3".. but that's fairly inefficient obviously...

any idea ? this script would be running on windows (cygwin installed). If there is a way to do so involving 3rd party software (eg. excel) then that's of interest too....

`A`

and`B`

vary as well? If so, can they simply be ignored? – DMA57361 Sep 8 '10 at 11:39