need a command to search for numbers greater than 3000

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

i have a file contains:

13213,A,300
3423,C,200
5563,A,201
3000,A,400
3000,A,402
3000,A,206
3000,A,303
3000,A,200
4233,N,204

i need to search for numbers in the first column are greater than 3000?

i have another issue if you can help me?
if i want to search in the second or the third columns what is the command that i can use to specify a specific column to search in .....

2

For the 1st column:

awk -F, '$1 > 3000' file

Adjust the column number for other columns, $2 for the 2nd column, $3 for the 3th column and so on.

3

thanks,

but i have another issue, i need to search in first column for numbers greater than 3000 then searching in the second column of the output for A or N then searching in the third column of the output for value starts with 2xx

i need the out put to be

5563,A,201
4233,N,204
4 
awk -F, '$1 > 3000 && $2 ~ /[AN]/ && $3 ~ /^2/ ' file
5

I'm very happy :b:

i'm sorry for asking alot but i'm new in unix world.

the last question please if i need to filter the first column with range starts from 2000 to 6000 instead of greater than 3000 condition

6 
$1 >= 2000 && $1 <= 6000
7

sorry i think you got me wrong, lets say that the file contains

0123318739,A,300,abcde
0120123456,C,200,xcvfe
0120453576,A,201,fgsa
0110445654,A,400,gcaz
0120432343,A,402,dewa
0129423,A,206,dea
0104323433,A,303,a
01232132134,A,200,a
0122344242,N,204,ghfs

i need from first column all numbers start from 01201xxxxx to 0122xxxxxx then from 2nd A or N then 3rd start with 2xx then 4th contains a (charcter)

8

This has already been answered here http://www.unix.com/unix-dummies-questions-answers/156998-need-help-searching-file-range.html\#post302509048

---------- Post updated at 03:05 PM ---------- Previous update was at 03:00 PM ----------

awk -F, '{x=0+substr($1,1,5)}(x>1200)&&(x<1230)&&($2~/(A|N)/)&&($3~/^2/)&&($4~/a/)' infile

use nawk if on solaris

# nawk -F, '{x=0+substr($1,1,5)}(x>1200)&&(x<1230)' infile
0120123456,C,200,xcvfe
0120453576,A,201,fgsa
0120432343,A,402,dewa
0122344242,N,204,ghfs
# nawk -F, '{x=0+substr($1,1,5)}(x>1200)&&(x<1230)&&($2~/(A|N)/)' infile
0120453576,A,201,fgsa
0120432343,A,402,dewa
0122344242,N,204,ghfs
# nawk -F, '{x=0+substr($1,1,5)}(x>1200)&&(x<1230)&&($2~/(A|N)/)&&($3~/^2/)' infile
0120453576,A,201,fgsa
0122344242,N,204,ghfs
# nawk -F, '{x=0+substr($1,1,5)}(x>1200)&&(x<1230)&&($2~/(A|N)/)&&($3~/^2/)&&($4~/a/)' infile
0120453576,A,201,fgsa
#