read numbers from file and output which numbers belongs to which range Post: 302315710

Sponsored Content

Top Forums Shell Programming and Scripting read numbers from file and output which numbers belongs to which range Post 302315710 by panyam on Wednesday 13th of May 2009 05:39:29 AM

05-13-2009

Registered User

Try the below code :

Code:

 
 
for i in `cat inp.txt`
do
j=`echo $i |awk '{ print substr($0,1,6) }'`
echo $j
awk -v inp=$j -v inpr=$i  'NF==3{tit=$1};NF==3{if(inp > $2 && inp < $3) print $1"----->"inpr};NF==2{if(inp > $1 && inp < $2) print tit"----->"inpr}' range_ref.txt >> output.txt
done

here wht i hav done :

Code:

 
TESTING>cat inp.txt
935303455
935479875
935477987
937499000
937492355
937860439
935393444
937431000
 
TESTING>cat range_ref.txt
Group0125       935300               935399
Group2006       935400               935476
                     937430               937459
Group0324       935477               935549
                     937480               937499
Group0404       935550               935625
                     937800               937879
 
TESTING>./awk_scr.sh
TESTING>cat output.txt
 
Group0125----->935303455
Group0324----->935479875
Group0324----->937492355
Group0404----->937860439
Group0125----->935393444
Group2006----->937431000

panyam

View Public Profile for panyam

Find all posts by panyam

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Using grep on a range of numbers

Hi im new to unix and need to find a way to grep the top 5 numbers in a file and put them into another file. For example my file looks like this abcdef 50000 abcdef 45000 abcdef 40000 abcdef 35000 abcdef 30000 abcdef 25000 abcdef 20000 abcdef 15000 abcdef 10000 and so on... How can...

2. Shell Programming and Scripting

Inserting a range of consecutive numbers into a text file

I have a text file in the following format .... START 1,1 2,1 3,1 .. .. 9,1 10,1 END .... I want to change to the output to .... START 1,1 2,1 3,1 ..

3. Shell Programming and Scripting

Help with addition of 2 numbers that are read from a file

I am trying to add free and used memory (so that i can compute percentage used)of remote nodes using shell script. I use the openssh-server,expect tool and ssh script. 1)login.txt (info of nodes): ip1|username|password ip2|username|password . . . 3)sshlogin.sh #!/bin/bash ...

4. UNIX for Dummies Questions & Answers

Frequency of a range of numbers

Hello, I have a column where there are values from 1 to 150. I want to get the frequency of values in the following ranges: 1-5 6-10 11-15 .... .... .... 146-150 How can I do this in a for loop? Thanks, Guss

5. UNIX for Dummies Questions & Answers

How to count how many numbers in a certain range?

Hi I have a data file with two columns which looks like: 1 42 2 40 3 55 4 50 5 38 6 49 7 33 8 46 9 39 10 33 11 33 12 26 13 46 14 44 15 55 16 54 17 30 18 32

6. Shell Programming and Scripting

the smallest number from 90% of highest numbers from all numbers in file

Hello All, I am having problem to find what is the smallest number from 90% of highest numbers from all numbers in file. I am having file with thousands of lines and hundreds of columns. I am familiar mainly with bash but I am open to whatever suggestion witch will lead to the solutions. If I...

7. Shell Programming and Scripting

Read numbers from file

I am trying to make a script to read marks from a file then find out how many of them are above 40 (passing marks). However my script is getting stuck at "read num". I dont understand whats the problem. Any help will be much appreciated. #!/bin/bash set -x count=0; countP=0; PASSMK=40...

8. Shell Programming and Scripting

Match on a range of numbers

Hi, I'm trying to match a filename that could be called anything from vout001 to vout252 and was trying to do a small test but I'm not getting the result I thought I would.. Can some one tell me what I'm doing wrong? *****@********>echo $mynumber ...

9. Shell Programming and Scripting

Adding (as in arithmetic) to numbers in columns in file, and writing new file with new numbers

Hi again. Sorry for all the questions — I've tried to do all this myself but I'm just not good enough yet, and the help I've received so far from bartus11 has been absolutely invaluable. Hopefully this will be the last bit of file manipulation I need to do. I have a file which is formatted as...

10. UNIX for Beginners Questions & Answers

Read a file with decimal numbers in bash

Hello, I have the following script while read id fraction do sambamba -h -f bam -t 10 --subsampling-seed=50 -s $frac ${id}.bam -o ${id}.out.bam done < fraction.txt where fraction.txt has two columns (id,fraction) and 50 rows I am unable to run this as bash is not able to read the second...

LEARN ABOUT DEBIAN

giiaddeventmask

giiSetEventMask(3)							GGI							giiSetEventMask(3)

NAME

       giiSetEventMask, giiGetEventMask, giiAddEventMask, giiRemoveEventMask - Set the types of events queued

SYNOPSIS

       #include <ggi/gii.h>

       int giiSetEventMask(gii_input_t inp, gii_event_mask evm);

       gii_event_mask giiGetEventMask(gii_input_t inp);

       int giiAddEventMask(gii_input_t inp, gii_event_mask evm);

       int giiRemoveEventMask(gii_input_t inp, gii_event_mask evm);

DESCRIPTION

       Calling	giiSetEventMask indicates to LibGII that only the types of events that match the specified event mask will be read by the applica-
       tion in subsequent giiEventPoll(3) or giiEventRead(3) calls.  LibGII can then save time and memory by skipping checks  and  not	allocating
       queues for events that will never be read out.  The default mask allows all events.

       giiAddEventMask and giiRemoveEventMask are macros that set or delete individual bits in the bitmask.
	      Note:  giiSetEventMask  is an advisory call.  For correct operation, the application still needs to pass a restrictive event mask to
	      the event reading functions.

RETURN VALUE

       giiSetEventMask, giiAddEventMask and giiRemoveEventMask return 0 on success or an gii-error(3) code otherwise.

       giiGetEventMask returns the currently set mask.

SEE ALSO

       gii_event_mask(3)

libgii-1.0.x							    2006-12-30							giiSetEventMask(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Using grep on a range of numbers

Discussion started by: ProgChick2oo9

2. Shell Programming and Scripting

Inserting a range of consecutive numbers into a text file

Discussion started by: VNR

3. Shell Programming and Scripting

Help with addition of 2 numbers that are read from a file

Discussion started by: marmik1903

4. UNIX for Dummies Questions & Answers

Frequency of a range of numbers

Discussion started by: Gussifinknottle