Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: match range of different numbers by AWK
Top Forums Shell Programming and Scripting match range of different numbers by AWK Post 302351343 by radoulov on Tuesday 8th of September 2009 08:56:08 AM
Old 09-08-2009
As far as the records B and C are concerned, you only need to comment the following statements (in red):

Code:
#!/usr/bin/awk -f

BEGIN {
OFS="\t"; ORS="\n" 
  def["ascoutlower"]    = "ARANGE"   
  def["ascoutupper"]    = "BRANGE"
  def["descoutlower"]   = "CRANGE"
  def["descoutupper"]   = "DRANGE"
  def["ascinnotexact"]  = "ERANGE"
  def["descinnotexact"] = "FRANGE"
  def["ascinexact"]     = "GRANGE"
  def["descinexact"]    = "HRANGE"
  
  }

NR == FNR && NF {
  NF > 2 && k = $1
  in2[k] = in2[k] ? in2[k] RS $1 FS $2 : $2 FS $3
  next
  }
$1 in in2 {
  n = split(in2[$1], tmp, RS) 
  split(tmp[1], Tmp); min = Tmp[1]
  m = split(tmp[n], Tmp); max = Tmp[m]
  # asc - desc
  Def = $2 > $3 ? "desc" : "asc"
  # inrange - outofrange
  if (Def == "asc")
    Def = Def ($2 >= min && $3 <= max ? "in" : "out") 
  else
    Def = Def ($3 >= min && $2 <= max ? "in" : "out")
  # lower - upper
  if ((Def ~ /ascout/ ? $3 : $2) <= min) {
    Def = Def "lower"
#    print $0 "\t" def[Def], Def
#    next
    }
  if ((Def ~ /ascout/ ? $3 : $2) >= max) {
    Def = Def "upper"
#    print $0 "\t" def[Def] "\t" Def
#    next
    }    
  # exact - not exact
  for (i=1; i<=n; i++) {
    split(tmp[i], range)
    if (Def ~ /asc/) { k1 = $2; k2 = $3 }      
    else { k1 = $3; k2 = $2 }
    if (k1 >= range[1] && k2 <= range[2]) {
      Def = Def "exact"
      print $0 "\t" def[Def] "\t" Def
      next
      }
    }
      Def = Def "notexact"
    print $0 "\t" def[Def] "\t" Def
    next    
}!/^[ \t]/ { print $0 "\tUNKNOWN" }

And you' ll get:

Code:
A       239861347 239858777     -               descoutnotexact
B       233849110 233849388     +               ascinlowerexact
C       202864284 202864396     +               ascinlowerexact
D       187984662 187982263     -               descoutnotexact

Now, what should be in and what should be out of range? As far as the D record is concerned, we get "out of range" because the range min value in the input2 file (187984054) is greater than the min value (187982263) in the file input1.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

match numbers (awk)

i would like to enter (user input) a bunch of numbers seperated by space: 10 15 20 25 and use awk to print out any lines in a file that have matching numbers so output is: 22 44 66 55 (10) 77 (20) (numbers 10 and 20 matched for example) is this possible in awk . im using gawk for... (5 Replies)
Discussion started by: tanku
5 Replies

2. Shell Programming and Scripting

Match real numbers in AWK

I am looking for a better way to match real numbers within a specified tolerance range. My current code is as follows: if ($1 !~ /^CASE/) for(i=1;i in G;i++) if (G >= $5-1 && G <= $5+1) { print $1,$4,$5,J,G } else { print $1,"NO MATCH" } where $5 and G are... (3 Replies)
Discussion started by: cold_Que
3 Replies

3. Shell Programming and Scripting

awk to match a numeric range specified by two columns

Hi Everyone, Here's a snippet of my data: File 1 = testRef2: A1BG - 13208 13284 AAA1 - 34758475 34873943 AAAS - 53701240 53715412File 2 = 42MLN.3.bedS2: 13208 13208 13360 13363 13484 13518 13518My awk script: awk 'NR == FNR{a=$1;next} {$1>=a}{$1<=a}{print... (5 Replies)
Discussion started by: heecha
5 Replies

4. Shell Programming and Scripting

Range of numbers in HEX using AWK

Hi , How do i found out all the number in a range ( HEX) for example Input is 15CF:15D2 Output needed 15CF 15D0 15D1 15D2 Thanks (2 Replies)
Discussion started by: greycells
2 Replies

5. Shell Programming and Scripting

Awk numeric range match only one digit?

Hello, I have a text file with lines that look like this: 1974 12 27 -0.72743 -1.0169 2 1.25029 1974 12 28 -0.4958 -0.72926 2 0.881839 1974 12 29 -0.26331 -0.53426 2 0.595623 1974 12 30 7.71432E-02 -0.71887 3 0.723001 1974 12 31 0.187789 -1.07114 3 1.08748 1975 1 1 0.349933 -1.02217... (2 Replies)
Discussion started by: meridionaljet
2 Replies

6. Shell Programming and Scripting

Complex match of numbers between 2 files awk script

Hello to all, I hope some awk guru could help me. I have 2 input files: File1: Is the complete database File2: Contains some numbers which I want to compare File1: "NUMBERKEY","SERVICENAME","PARAMETERNAME","PARAMETERVALUE","ALTERNATENUMBERKEY"... (9 Replies)
Discussion started by: Ophiuchus
9 Replies

7. Shell Programming and Scripting

awk : match only the pattern string , not letters or numbers after that.

Hi Experts, I am finding difficulty to get exact match: file OPERATING_SYSTEM=HP-UX LOOPBACK_ADDRESS=127.0.0.1 INTERFACE_NAME="lan3" IP_ADDRESS="10.53.52.241" SUBNET_MASK="255.255.255.192" BROADCAST_ADDRESS="" INTERFACE_STATE="" DHCP_ENABLE=0 INTERFACE_NAME="lan3:1"... (6 Replies)
Discussion started by: rveri
6 Replies

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 ... (4 Replies)
Discussion started by: Jazmania
4 Replies

9. Shell Programming and Scripting

Get range out using sed or awk, only if given pattern match

Input: START OS:: UNIX Release: xxx Version: xxx END START OS:: LINUX Release: xxx Version: xxx END START OS:: Windows Release: xxx Version: xxx ENDHere i am trying to get all the information between START and END, only if i could match OS Type. I can get all the data between the... (3 Replies)
Discussion started by: Dharmaraja
3 Replies

10. Shell Programming and Scripting

awk to print text in field if match and range is met

In the awk below I am trying to match the value in $4 of file1 with the split value from $4 in file2. I store the value of $4 in file1 in A and the split value (using the _ for the split) in array. I then strore the value in $2 as min, the value in $3 as max, and the value in $1 as chr. If A is... (6 Replies)
Discussion started by: cmccabe
6 Replies

LEARN ABOUT DEBIAN

numm.one-bit-instrument

one-bit-instrument(7)						  Numm Tutorials					     one-bit-instrument(7)

NAME

       one bit instrument - how to make a gnarly synth with numm-run

SYNOPSIS

       numm-run FILE

DESCRIPTION

       In  this  tutorial we will learn how to live-code a one-bit synthesizer controlled by mouse position.  It is intended as a gentle introduc-
       tion to development with numm-run.

       To get started, create a text file with the following method stubs:

	      def audio_out(a):
		  pass
	      def video_out(a):
		  pass

       Save the file as onebit.py, and then launch it with numm-run:

	      numm-run onebit.py

       You should see a blank window appear.  We will now make some sound and light by changing the value of a	in  the  audio_out  and  video_out
       functions:

	      def audio_out(a):
		  a[::100] = 2**15
	      def video_out(a):
		  a.flat[::100] = 255

       Save  the  file,  and you should see and hear the sketch update.  This is using numpy's array-indexing to turn every hundredth audio sample
       and pixel-color on.  The audio sample rate is by default 44100Hz, so it produces a series of clicks that will be perceived as a 441Hz tone.
       We can turn this into an instrument by connecting mouse motion to frequency:

	      period = 100
	      def audio_out(a):
		  a[::period] = 2**15
	      def video_out(a):
		  a.flat[::period] = 255
	      def mouse_in(type,px,py,button):
		  global period
		  period = px*1000

       Finally, let's use the keyboard to record and jump to notes.  The first time you press a key, it records the period, and subsequant depres-
       sions play the saved period:

	      period = 100
	      record = {}
	      def audio_out(a):
		  a[::period] = 2**15
	      def video_out(a):
		  a.flat[::period] = 255
	      def mouse_in(type,px,py,button):
		  global period
		  period = px*1000
	      def keyboard_in(type,key):
		  global period
		  if record.has_key(key):
		      period = record[key]
		  elif record.has_key(key):
		      record[] = period

SEE ALSO

       numm-run(1), numm.getting-started(7), numm.spectral-analysis(7)

numm								   February 2012					     one-bit-instrument(7)
All times are GMT -4. The time now is 10:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy