Shell Programming and Scripting

Hello,
I have many csv file, but I would like to delete lines with some values in a column conditionally.

My example look like this,

ex1e, ex2g, ex39, pasg, ssg, mrlc, pc, kb, coop
-112, -53, -177, 64, 62, 71, 1, 487, 20
-101, -61, -53, 0, 32767, 51, 0, 239, 30
-57, -95, -215, 144, 174, 42, 0, 316, 12
23, 47, 32, 42, -300, 71, 0, 112, -23
11, 45, 44, -20, 300, 51, 1, 279, 32
31, 52, 63, 74, 301, 40, 1, 28, -2
82, 35, 23, 77, -299, 51, 1, 0, -1

What I want to do is to look at the field, ssg (column5), then find values only greater than or equal to -300 and less than or equal to 300. So, the result should be look like this.
ex1e, ex2g, ex39, pasg, ssg, mrlc, pc, kb, coop
-112, -53, -177, 64, 62, 71, 1, 487, 20
-57, -95, -215, 144, 174, 42, 0, 316, 12
23, 47, 32, 42, -300, 71, 0, 112, -23
11, 45, 44, -20, 300, 51, 1, 279, 32
82, 35, 23, 77, -299, 51, 1, 0, -1

I tried to use sed below, but I got stuck after that.
sed '/^\([^,]*,\)\{6\}300,......

Please help me.

Jae

Code:

awk -F", " '{ if ( $5 >= -300 && $5 <= 300 ) { print } }' filename

Thank you for code, matrixmadhan.
But, header row was removed.
I want to keep header row, so the result should be.

ex1e, ex2g, ex39, pasg, ssg, mrlc, pc, kb, coop
-112, -53, -177, 64, 62, 71, 1, 487, 20
-57, -95, -215, 144, 174, 42, 0, 316, 12
23, 47, 32, 42, -300, 71, 0, 112, -23
11, 45, 44, -20, 300, 51, 1, 279, 32
82, 35, 23, 77, -299, 51, 1, 0, -1

Thanks,

Jae

Here is one way keeping the header:

Code:

#!/bin/ksh
typeset -i f5
sed '1q' input_file
IFS=','
sed '1d' input_file | \
while read f1 f2 f3 f4 f5 f6 f7 f8 f9
do
  if [ ${f5} -ge -300 -a ${f5} -le 300 ]; then
    echo $f1','$f2','$f3','$f4','$f5','$f6','$f7','$f8','$f9
  fi
done

Code:

awk -F", " '{ if ( NR == 1 ) { print }; if ( $5 >= -300 && $5 <= 300 ) { print } }' filename

I know this is not a cleaner way !

Thank you for code, matrixmadhan and Shell_life.
But, I simply do that, looks dirty though.
head -1 filename > filename1.csv
awk -F", " '{ if ( $5 >= -300 && $5 <= 300 ) { print } }' filename >> filename1.csv

Cheers,

Jae

Code:

nawk -F',' 'FNR>1 && $5 >= -300 && $5 <= 300' filename