UNIX for Dummies Questions & Answers

Hi all,

I require assistance in this.

I'd like to filter the following data to extract WADRAIN.

RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 24109, 1011, 1.6, 0, 6,
RAIN, 2003-01-01 00:00, 1, DLY3208, 900, 1, 30747, 1011, 1.8, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 24775, 1011, 2.8, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 1622, 1011, 2.7, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 1624, 1011, 1.8, 0, 6,
RAIN, 2003-01-01 00:00, 1, WAMRAIN, 900, 31, 24953, 1011, 84.5, 0, 6,
RAIN, 2003-01-01 00:00, 0, DLY3208, 900, 1, 24953, 1012, 1, 0, 1,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 31, 24953, 1022, 84, 0, 22576,

The eventual output I want is;

RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 24109, 1011, 1.6, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 24775, 1011, 2.8, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 1622, 1011, 2.7, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 1624, 1011, 1.8, 0, 6,
RAIN, 2003-01-01 00:00, 1, WAMRAIN, 900, 31, 24953, 1011, 84.5, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 31, 24953, 1022, 84, 0, 22576,

Thanks!

Hi.

Code:

man grep

Thanks scottn,

I did

> grep -H "WADRAIN" infile.txt > outfile.txt

and got what I wanted.

This is relatively straightforward but I also want to filter data from other columns (containing 1s and 0s) after extracting "WADRAIN". For example, how do I filter the rows containing 1s from, say, column 4?

Example:

RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 24109, 1011, 1.6, 0, 6,
RAIN, 2003-01-01 00:00, 0, WADRAIN, 900, 1, 24775, 1011, 2.8, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 1622, 1011, 2.7, 0, 6,
RAIN, 2003-01-01 00:00, 0, WADRAIN, 900, 1, 1624, 1011, 1.8, 0, 6,
RAIN, 2003-01-01 00:00, 1, WAMRAIN, 900, 31, 24953, 1011, 84.5, 0, 6,
RAIN, 2003-01-01 00:00, 0, WADRAIN, 900, 31, 24953, 1022, 84, 0, 22576,

Desired result:
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 24109, 1011, 1.6, 0, 6,
RAIN, 2003-01-01 00:00, 1, WADRAIN, 900, 1, 1622, 1011, 2.7, 0, 6,
RAIN, 2003-01-01 00:00, 1, WAMRAIN, 900, 31, 24953, 1011, 84.5, 0, 6,

Thanks!

then use awk...

Code:

awk -F"," '/WADRAIN/&&$3==1{print}' filename

Thanks vidyadhar85,

Could you tell me what the syntax means?

Hi.

It means if the line contains the string WADRAIN and field three contains the number 1, then print the line

Fields are separated by a comma (-F",")

If you want WAMRAIN too, then:

Code:

awk -F, '/WA[DM]RAIN/ && $3' filename

Thanks scottn!