UNIX for Dummies Questions & Answers

i have a file contains:

Code:

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 .....

For the 1st column:

Code:

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.

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

Code:

5563,A,201
4233,N,204

Code:

awk -F, '$1 > 3000 && $2 ~ /[AN]/ && $3 ~ /^2/ ' file

I'm very happy

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

Code:

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

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)