|
|||||||
| Forums | Search Forums | Register | Forum Rules | Man Pages | Albums | FAQ | Members | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
using grep for find values larger/less than
Hi I have been experimenting with grep to find values for a particular column that is greater than or less than certain #'s. So my file looks like this: Code:
name -2 2 name1 -2 2 name2 -1 4 name3 3 3 So I want to find rows with values less than or equal to -2 and those greater than or equal to 3 (for column2 only) Then the output would look like this: Code:
name -2 2 name1 -2 3 name3 3 3 I tried grep but I am very lost with it.. thanks |
| Sponsored Links | ||
|
|
#2
|
||||
|
||||
|
Horses for courses.
Why bust a gut with grep when other tools make light work of this sort of thing? |
| Sponsored Links | ||
|
|
#3
|
|||
|
|||
|
example awk oneliner: Code:
awk ' $2<=-2 || $2>=3' myfile |
|
#4
|
|||
|
|||
|
hi thank you for the solution. It works..
what if I want to find something within a range lets say between -2 and 3. Obviously the directions of the arrows wont work. thanks |
| Sponsored Links | |
|
|
#5
|
||||
|
||||
|
Hi Phil, have you tried reversing the comparison operators? You can find out from Jim's solution what they look like.
|
| Sponsored Links | |
|
|
#6
|
|||
|
|||
|
Hey, yeah I tried that but that will give everything greater than -3 and everything less than 2. Code:
5 4 3 2 1 0 -1 -2 -3 -4 -5 So lets I wanted the range of values to be -3 to 2 then the values being pulled out would be Code:
2 1 0 -1 -2 -3 but instead if I only reversed teh arrows, I get everything greater than -3 and everything less than 2 ---------- Post updated at 05:32 PM ---------- Previous update was at 05:14 PM ---------- Code:
awk ' $2>=-2 && $2<=3' this seems to work i think... Last edited by phil_heath; 11-18-2009 at 05:40 PM.. |
| Sponsored Links | ||
|
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to find a file whick is consuming larger disk space in file system | lokeshpashine | UNIX for Dummies Questions & Answers | 6 | 04-04-2009 02:52 AM |
| grep two values together. | tushar_tus | Shell Programming and Scripting | 1 | 02-24-2009 05:40 AM |
| using a vaiable parameters and values to find and tar | jjminkle | Shell Programming and Scripting | 1 | 05-02-2008 05:12 PM |
| grep using ASCII values | sriksama | UNIX for Dummies Questions & Answers | 1 | 01-09-2008 10:26 AM |
| grep a list of values | jolan_louve | Shell Programming and Scripting | 3 | 12-06-2006 01:18 AM |
|
|