AWK - Awk to match two conditions

Author

Awk to match two conditions

bshah@citadon.com

2006-03-30, 6:56 pm

Hi Gurus,
With your help i had a script which was successfully getting all
entries which had first col. ranges between 50 and 350. I need to
modify this to give me output where first entry ($1) will range between
50 and 350 and second filed matches between [a-d]* and [l-q]*
basically sencond field which starts with [a-d]* or [l-q]*

INPUT_FILE
-------------------
21516 desno
10522 tcos
7855 lis
7255 fla
7018 dusdsd
6640 ant
6580 kfddg
6462 megfi
6432 lnic

awk '$1 >= 50 && $1 <= 350 { total+=$1;print $2} END { print total "
MB" > "/dev/tty" }' INPUT_FILE> OUTPUT_FILE

Regards
tester

Janis Papanagnou

2006-03-30, 6:56 pm

bshah@citadon.com wrote:
> Hi Gurus,
> With your help i had a script which was successfully getting all
> entries which had first col. ranges between 50 and 350. I need to
> modify this to give me output where first entry ($1) will range between
> 50 and 350 and second filed matches between [a-d]* and [l-q]*
> basically sencond field which starts with [a-d]* or [l-q]*

Do you mean a literal * or just the letters? Try this...

$1 >= 50 && $1 <= 350 && $2 ~ /^[a-dl-q]/ { ... }

Janis

> INPUT_FILE
> -------------------
> 21516 desno
> 10522 tcos
> 7855 lis
> 7255 fla
> 7018 dusdsd
> 6640 ant
> 6580 kfddg
> 6462 megfi
> 6432 lnic
>
>
> awk '$1 >= 50 && $1 <= 350 { total+=$1;print $2} END { print total "
> MB" > "/dev/tty" }' INPUT_FILE> OUTPUT_FILE
>
> Regards
> tester
>

Sponsored Links