Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Awk - select from a list

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Awk - select from a list
# 8  
Old 02-06-2008
Quote:
Originally Posted by simha77777
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.

Smilie
strange - works just fine under Sun/Solaris.

quote your files using vB Codes here as there appear exactly. There must be something dirrect iwth your input files.
# 9  
Old 02-06-2008
Opps my bad. It works perfectly for printing column in the numberList that match the myFile

If I understand your solution right - we can print only the 14th coulmn from the myFile right?
I actually want to print out other columns from the myFile which match the number in the numberList file (May be the 74th coulmn).
Hope I am not asking too much.Smilie
# 10  
Old 02-06-2008
to match on the 14-th column and print the 74-th?
Code:
$14 in numList {print $74}

# 11  
Old 02-06-2008
Kool! vgersh99 thats exactly what i wanted.

How do I handle the case when my file myFile is tab delimited
# 12  
Old 02-06-2008
Quote:
Originally Posted by simha77777
Kool! vgersh99 thats exactly what i wanted.

How do I handle the case when my file myFile is tab delimited
nawk should handle that: regardless whether it's space or TAB delimited.
# 13  
Old 02-06-2008
Thanks for the information.

In my case the delimiter is tab and the fields can have space in them.
This is causing it to give improper results
What do I need to use to specify the tab delimiter?
# 14  
Old 02-06-2008
Quote:
Originally Posted by simha77777
Thanks for the information.

In my case the delimiter is tab and the fields can have space in them.
This is causing it to give improper results
What do I need to use to specify the tab delimiter?
Code:
nawk -F '[\t]' -f simha.awk numberList myFile

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Scripting - Select multiple files from numbered list

I am trying to have the user select two files from a numbered list which will eventually be turned into a variable then combined. This is probably something simple and stupid that I am doing. clear echo "Please Select the Show interface status file" select FILE1 in *; echo "Please Select the... (3 Replies)
Discussion started by: dis0wned
3 Replies

2. UNIX for Dummies Questions & Answers

Select distinct sequences from fasta file and list

Hi How can I extract sequences from a fasta file with respect a certain criteria? The beginning of my file (containing in total more than 1000 sequences) looks like this: >H8V34IS02I59VP SDACNDLTIALLQIAREVRVCNPTFSFRWHPQVKDEVMRECFDCIRQGLG YPSMRNDPILIANCMNWHGHPLEEARQWVHQACMSPCPSTKHGFQPFRMA... (6 Replies)
Discussion started by: Marion MPI
6 Replies

3. Shell Programming and Scripting

Select only the lines of a file starting with a field which is matcing a list. awk?

Hello I have a large file1 which has many events like "2014010420" and following lines under each event that start with text . It has this form: 2014010420 num --- --- num .... NTE num num --- num... EFA num num --- num ... LASW num num --- num... (9 Replies)
Discussion started by: phaethon
9 Replies

4. Shell Programming and Scripting

How to use a multiple line list with the select command in ksh?

I copied the below program to play around with displaying a list of items using the select command in ksh. When I put all items in the same line, it works fine. I am trying to use multiple lines instead of a single row...my list is too large for a single line. How do I get the line continuation... (3 Replies)
Discussion started by: haganator
3 Replies

5. Shell Programming and Scripting

How to process select list of files and output to the same file?

Hi, I've a list of files ac_info.tps, subscription_array.tps, .......and many other files one of the file, bin_range_list.tps has the following content CREATE OR REPLACE TYPE "BIN_RANGE_LIST" AS TABLE OF BIN_RANGE_ELEM; / grant execute on... (4 Replies)
Discussion started by: jediwannabe
4 Replies

6. Shell Programming and Scripting

Like to select text in a From/To list

Hi I need help to configure AWK to find a string based From/To filed I have a table like this 0A00 - 0AFF Nuts 0B00 - 0BFF Bolt If I have in a program a value like "0B22" I wold like to get "Bolt" in return. List are in Hex Still try to learn AWK :) (3 Replies)
Discussion started by: Jotne
3 Replies

7. UNIX Desktop Questions & Answers

Script to select a file from a list

i m trying to write a script that will print all the txt files at /home/ directory and will allow a selection of a file and then print the file name. this is what i wrote so far: echo "please select the file from the list " list=$(ls -f *.txt /home/) array=( ) for machine in $list doat... (1 Reply)
Discussion started by: boaz733
1 Replies

8. Shell Programming and Scripting

select data from list

Hi! My data file contains a two columns list. It looks like: 1 3.789 2 6.789 3 7.890 4 8.900 5 6.789 6 1.987 7 10.987 8 2.987 9 0.987 I would like to create a new list using the awk command, just selecting data from the second column but also printing the first column. Let say I select... (3 Replies)
Discussion started by: cris48
3 Replies

9. Shell Programming and Scripting

retrieve what the currently selected item is in a dropdown select list using perl tk

I have a dropdown menu built in perl tk (I am using active state perl). I want to select a value from the dropdown menu and I want to be able to perform some other actions depending upon what value is selected. I have all the graphical part made but I dont know how to get the selected value. Any... (0 Replies)
Discussion started by: lassimanji
0 Replies

10. Shell Programming and Scripting

reappearing menu list using select

is there a way I can make the menu list reappear when I use select ? ----- menulist="Change_title Remove_tag Change_tag Add_line Quit" select word in $menulist #change_title remove_tag change_tag add_line quit do case $word in # first menu option Change Title ... (9 Replies)
Discussion started by: forever_49ers
9 Replies
Login or Register to Ask a Question