The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
.
google unix.com



UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
select vs poll smanu IP Networking 12 04-30-2007 05:22 PM
reappearing menu list using select forever_49ers Shell Programming and Scripting 9 09-13-2006 04:05 PM
how to generate a random list from a given list mskcc Shell Programming and Scripting 3 05-30-2006 03:30 AM
Comparing a distinct value in 1 list with another list manualvin Shell Programming and Scripting 6 06-22-2004 06:42 AM
select() and read() jnuno High Level Programming 2 11-19-2002 02:03 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish
 
LinkBack Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
  #1 (permalink)  
Old 02-06-2008
simha77777 simha77777 is offline
Registered User
  
 

Join Date: Jul 2006
Posts: 8
Awk - select from a list

Hi all,

I am trying to select some columns from a file, based on the list of values.
Would like to know how best I can achive this.

If coulmn 1 has a value of 57 then print the ist column (This works)
Code:
awk -F'  ' '{if ( $1 == 57 ) {print $1}}' file.txt
Now my requirement is that I have to check the column with multiple values. (If I have 2 use an OR operator as below)
Code:
awk -F'  ' '{if ( $1 == 57 || $1 == 58) {print $1}}' file.txt
I have 100 values which I need to check with the first column. Is there a way to do this, without writing in 100 conditions in the if statement?
(I could put the 100 values into a file if that makes things easier)

Please let me know if you need more information. Any help greatly appreciated.
  #2 (permalink)  
Old 02-06-2008
Yogesh Sawant's Avatar
Yogesh Sawant Yogesh Sawant is offline Forum Staff  
Part Time Moderator and Full Time Dad
  
 

Join Date: Sep 2006
Location: Rossem, Tazenda
Posts: 1,086
how about putting a regex instead of those hundred comparisons?
  #3 (permalink)  
Old 02-06-2008
simha77777 simha77777 is offline
Registered User
  
 

Join Date: Jul 2006
Posts: 8
Thank you for the response.

In my case, I don't have a definite pattern to use as a regexp, I would have to pass a list of numbers, which might not be in a sequence.
HTH
  #4 (permalink)  
Old 02-06-2008
vgersh99's Avatar
vgersh99 vgersh99 is online now Forum Staff  
Moderator
  
 

Join Date: Feb 2005
Location: Boston, MA
Posts: 5,116
assuming numberList is a file containing 'numbers' to be filtered - one number per line.
And 'myFile' is a file to check the numbers against.

nawk -f simha.awk numberList myFile

simha.awk:
Code:
NR==FNR { numList[$1]; next}
$1 in numList {print $1}
  #5 (permalink)  
Old 02-06-2008
simha77777 simha77777 is offline
Registered User
  
 

Join Date: Jul 2006
Posts: 8
vgersh99,

Pardon my ignorance -
Just a little clarification needed here.
numList and numberList mismatch is a typo or it needs to be that way?

Also how do I check for a particular coulmn in the myFile (for example the 14th coulmn). The delimiter is tab in myFile.

Thanks for your time.
  #6 (permalink)  
Old 02-06-2008
vgersh99's Avatar
vgersh99 vgersh99 is online now Forum Staff  
Moderator
  
 

Join Date: Feb 2005
Location: Boston, MA
Posts: 5,116
Quote:
Originally Posted by simha77777 View Post
vgersh99,

Pardon my ignorance -
Just a little clarification needed here.
numList and numberList mismatch is a typo or it needs to be that way?
no, it's not a typo - it can be anything
Quote:
Originally Posted by simha77777 View Post
Also how do I check for a particular coulmn in the myFile (for example the 14th coulmn). The delimiter is tab in myFile.

Thanks for your time.
if it's the 14-th column in the myFile, then change this:
Code:
$1 in numList {print $1}
to this:
Code:
$14 in numList {print $14}
  #7 (permalink)  
Old 02-06-2008
simha77777 simha77777 is offline
Registered User
  
 

Join Date: Jul 2006
Posts: 8
Not sure what I am doing wrong, but I am not getting any results when i run the command
Code:
nawk -f simha.awk numberList myFile
numberList is my single column file with the numbers which are used to compare.
myFile is my tab delimited file whose 14th colunm needs to be compared to the values in the numberList file.
simha.awk has the exact code you have specified (The one with 14)

Appreciate your help so far.

Sponsored Links
Closed Thread

Bookmarks

Tags
awk, nawk

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 06:26 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language translation by Google.
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0