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 302336781 by stateperl on Wednesday 22nd of July 2009 08:45:28 PM
Old 07-22-2009
Elaborative
There are 2 inputfiles as I mentioned, Input1 and Input2.
Input1 has 3 columns. 1st one has keyvalues and 2nd ones has sub key values and 3rd one has numerical values (ranges like from 5-10, 30-40)
Code:
input1

a	a1	5-10
		30-40
		45-60
		80-90
		100-120
x       a2    10-20
                50-60

Input2 has also 3 columns exactly like input1.1st one with key and 2nd one with subkey and 3rd one with various ranges of numbers like 1-4,1-4,120-140,140-120
Code:
input2

a	a1	1-4
a	a1	4-1
a	a1	120-140
a	a1	140-120
a	a1	65-69
		70-100
a	a1	70-65
		44-40
a	a1	6-7
		37-57
		63-83
a	a1	7-8

Now I need to name the input2 value ranges according the ranges given in input 1 like in the following output
Code:
output

a	a1	1-4		outofrange1
a	a1	4-1		outofrange2
a	a1	120-140     outofrange3
a	a1	140-12      outofrange4
a	a1	65-69	        inrange1
		70-100
a	a1	70-65  	inrange2
		44-40	
a	a1	6-7            inrange3
a	a1	7-8            inrange4

As you can see 1-4 (the values from 1 to 4 in input2 are absent in input1) giving the name as outofrange1.

2nd one is little bit trciky if the value range is from high to low like 4-1 (the values from 4 to 1 in input2 are absent in input1). though it looks same as 1st case it has high value to low value range like 4 to 1. and given name as outofrange2

outofrange3 is same as outofrange1
outofrange4 is same as outofrange2

5th one, 65-69, inrange1 (the values from 65 to 69 in input2 are present in between the ranges in input1 but not with in the exact ranges giving the name as inrange1.

45-60 65-69 80-90

inrange2.[/B] is the trickiest version of inrange1.[/B](I mentioned before in ouofrange2)

7th one , 6-7, inrange3 (the values 6 to 7 in input 2 are exactly present in between the values of input 1), inrange3.

5 6-7 10

inrange4.[/B] is the trickiest version of inrange2.[/B]

And most importantly we are comparing the first range values of all the keys in input2 with all the key values in input1 like a-a1-65-69 with all the values in input2 a -a1- 5-10, 30-40, 45-60,80-90, 100-120



Hope it elucidate every thing clearlySmilie
Last edited by stateperl; 07-23-2009 at 12:02 AM..
 

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 OSF1

deckanji

deckanji(5)							File Formats Manual						       deckanji(5)

NAME

       deckanji - A character encoding system (codeset) for Japanese

DESCRIPTION

       The DEC Kanji codeset consists of the following characters: ASCII or JIS X0201 Roman letters Katakana characters specified by JIS X0201 JIS
       X0208 characters User-defined characters (UDC)

       DEC Kanji uses a combination of single-byte data and two-byte data to represent these characters.

       JIS X0201 is a single-byte character set and consists of Roman letters and Katakana characters, which are Japanese  phonetic  symbols.  The
       Roman  letters  defined in the JIS X0201-1976 standard are the same as ASCII letters. (For information on the ASCII character set, refer to
       ascii(5).) However, JIS X0201 replaces the ASCII tilde (~) character with a horizontal bar (located at the upper part of a character cell),
       and replaces the backslash () with the Japanese currency sign (Yen).

       The JIS XO208 standard specifies two-byte character values that represent a variety of characters, including ideographic symbols.

   DEC Kanji Encoding
       All ASCII characters are represented by single-byte 7-bit values in DEC Kanji. That is, the most significant bit (MSB) is always set off in
       the byte that represents an ASCII character. The Roman letters and the Katakana characters specified by JIS X0201 are also single-byte val-
       ues in which the most significant bit (MSB) is set off and on, respectively.

       The  code  table  for JIS X0208 characters is divided into 94 rows, numbered from 1 to 94. Each row has 94 columns, also numbered from 1 to
       94. JIS X0208 defines a total of 6877 characters which include: Special symbols, in rows 1 and 2 Numerals and Roman letters, in row 3 Hira-
       gana  characters, in row 4 Katakana characters, in row 5 Greek letters, in row 6 Russian letters, in row 7 Symbols for drawing graphs, dia-
       grams, and lines, in row 8 First level Kanji characters, in rows 16 to 47 Second level Kanji characters, in rows 48 to 84

       To comply with the JIS X0208 standard, each JIS X0208 character is a two-byte value in the DEC Kanji codeset. The MSB of both the first and
       second bytes is always set on to distinguish JIS X0208 characters from ASCII/JIS Roman or user-defined characters.

       For each JIS X0208 character, The first byte of the two-byte value determines the row number and the second determines the column number in
       the JIS X0208 code table. The following formula shows the code value for a JIS X0208 character in relation to its row and column numbers:

       1st byte = A0 + Row number
       2nd byte = A0 + Column number

       For example, if a character is positioned at the first column of the 36th row, its code value is C4A1, which is calculated as follows:

       1st byte = A0 (hex) + 36 = C4 (hex)
       2nd byte = A0 (hex) + 01 = A1 (hex)

       For user-defined character (UDC) definitions, DEC Kanji provides an area of 2914 positions (from row 1 to row 31). Each UDC is  represented
       by  a two-byte value, just like a JIS X0208 character value. However, the MSB of the second byte of a UDC is set off to distinguish it from
       a JIS X0208 character. The code range of the UDC area is A121 to BF7E.

       The following formula calculates the code of a UDC in relation to its row and column numbers:

       1st byte = A0 + Row number
       2nd byte = 20 + Column number

       For example, if a UDC is positioned at the first column of the 16th row, its code value is B021, which is calculated as follows:

       1st byte = A0 (hex) + 16 = B0 (hex)
       2nd byte = 20 (hex) + 01 = 21 (hex)

   Codeset Conversion
       The following codeset converter pairs are available for converting Japanese characters between deckanji and other encoding formats.   Refer
       to  iconv_intro(5)  for an introduction to codeset conversion. For more information about the other codeset for which deckanji is the input
       or output, see the reference page specified in the list item.  eucJP_deckanji, deckanji_eucJP

	      Converting from and to Japanese Extended UNIX Code: eucJP(5).  iso-2022-jp_deckanji, deckanji_iso-2022-jp

	      Converting from and to the ISO 2022-JP codeset: iso2022jp(5).  iso-2022-jpext_deckanji, deckanji_iso-2022-jpext

	      Converting from and to the ISO 2022-JPexp codeset: iso2022jp(5).	JIS7_deckanji, deckanji_JIS7

	      Converting from and to the JIS7 codeset: jiskanji(5).  sdeckanji_deckanji, deckanji_sdeckanji

	      Converting from and to the Super DEC Kanji codeset: sdeckanji(5).  SJIS_deckanji, deckanji_SJIS

	      Converting from and to the Shift JIS codeset: shiftjis(5).

	      Note that Shift JIS encoding is equivalent to the Microsoft code-page format used on PCs for Japanese. Therefore, you can use  these
	      converters to convert data between DEC Kanji and PC code-page format. For information on PC code pages, see code_page(5) UCS-2_deck-
	      anji, deckanji_UCS-2

	      Converting from and to UCS-2 format: Unicode(5).	UCS-4_deckanji, deckanji_UCS-4

	      Converting from and to UCS-4 format: Unicode(5).	UTF-8_deckanji, deckanji_UTF-8

	      Converting from and to UTF--8 format: Unicode(5).

   Japanese Fonts
       The operating system provides the following Japanese bitmap fonts in various sizes and typefaces for 75dpi and 100dpi  (dot-per-inch)  dis-
       play devices: JIS X0201-1976 characters (Gothic family):

	      -jdecw-gothic-medium-r-normal--8-80-75-75-m-40-jisx0201.1976-0	  -jdecw-gothic-medium-r-normal--14-140-75-75-m-70-jisx0201.1976-0
	      -jdecw-gothic-medium-r-normal--12-120-75-75-m-60-jisx0201.1976-0	 -jdecw-gothic-medium-r-normal--24-240-75-75-m-120-jisx0201.1976-0
	      -jdecw-gothic-medium-r-normal--10-100-75-75-m-50-jisx0201.1976-0	  -jdecw-gothic-medium-r-normal--18-180-75-75-m-90-jisx0201.1976-0
	      -jdecw-gothic-medium-r-normal--17-120-100-100-m-85-jisx0201.1976-0				       -jdecw-gothic-medium-r-nor-
	      mal--34-240-100-100-m-170-jisx0201.1976-0 -jdecw-gothic-medium-r-normal--14-100-100-100-m-70-jisx0201.1976-0 -jdecw-gothic-medium-r-
	      normal--25-180-100-100-m-125-jisx0201.1976-0   -jdecw-gothic-medium-r-normal--20-140-100-100-m-100-jisx0201.1976-0    -jdecw-gothic-
	      medium-r-normal--11-80-100-100-m-55-jisx0201.1976-0 JIS X0201-1976 characters (Kmenu family)

	      -jdecw-kmenu-medium-r-normal--12-120-75-75-p-70-jisx0201.1976-0	 -jdecw-kmenu-medium-r-normal--17-120-100-100-p-85-jisx0201.1976-0
	      JIS X0201-1976 characters (Mincho family)

	      -jdecw-mincho-medium-r-normal--8-80-75-75-m-40-jisx0201.1976-0	  -jdecw-mincho-medium-r-normal--14-140-75-75-m-70-jisx0201.1976-0
	      -jdecw-mincho-medium-r-normal--24-240-75-75-m-120-jisx0201.1976-0   -jdecw-mincho-medium-r-normal--10-100-75-75-m-50-jisx0201.1976-0
	      -jdecw-mincho-medium-r-normal--18-180-75-75-m-90-jisx0201.1976-0	-jdecw-mincho-medium-r-normal--17-120-100-100-m-85-jisx0201.1976-0
	      -jdecw-mincho-medium-r-normal--34-240-100-100-m-170-jisx0201.1976-0				       -jdecw-mincho-medium-r-nor-
	      mal--14-100-100-100-m-70-jisx0201.1976-0 -jdecw-mincho-medium-r-normal--25-180-100-100-m-125-jisx0201.1976-0 -jdecw-mincho-medium-r-
	      normal--20-140-100-100-m-100-jisx0201.1976-0  -jdecw-mincho-medium-r-normal--11-80-100-100-m-55-jisx0201.1976-0 JIS X0201-1976 char-
	      acters (Screen family)

	      -jdecw-screen-medium-r-normal--24-240-75-75-m-120-jisx0201-romankana				       -jdecw-screen-medium-r-nor-
	      mal--18-180-75-75-m-80-jisx0201-romankana  -jdecw-screen-medium-r-normal--14-140-75-75-m-70-jisx0201-romankana -jdecw-screen-medium-
	      r-normal--10-100-75-75-m-50-jisx0201-romankana JIS X0208 characters (Gothic family)

	      -jdecw-gothic-medium-r-normal--14-140-75-75-m-140-jisx0208.1983-1  -jdecw-gothic-medium-r-normal--12-120-75-75-m-120-jisx0208.1983-1
	      -jdecw-gothic-medium-r-normal--24-240-75-75-m-240-jisx0208.1983-1  -jdecw-gothic-medium-r-normal--10-100-75-75-m-100-jisx0208.1983-1
	      -jdecw-gothic-medium-r-normal--18-180-75-75-m-180-jisx0208.1983-1     -jdecw-gothic-medium-r-normal--8-80-75-75-m-80-jisx0208.1983-1
	      -jdecw-gothic-medium-r-normal--17-120-100-100-m-170-jisx0208.1983-1				       -jdecw-gothic-medium-r-nor-
	      mal--34-240-100-100-m-340-jisx0208.1983-1 -jdecw-gothic-medium-r-normal--14-100-100-100-m-140-jisx0208.1983-1  -jdecw-gothic-medium-
	      r-normal--25-180-100-100-m-250-jisx0208.1983-1   -jdecw-gothic-medium-r-normal--20-140-100-100-m-200-jisx0208.1983-1  -jdecw-gothic-
	      medium-r-normal--11-80-100-100-m-110-jisx0208.1983-1 JIS X0208 characters (Mincho family)

	      -jdecw-mincho-medium-r-normal--14-140-75-75-m-140-jisx0208.1983-1   jdecw-mincho-medium-r-normal--12-120-75-75-m-120-jisx0208.1983-1
	      -jdecw-mincho-medium-r-normal--24-240-75-75-m-240-jisx0208.1983-1  -jdecw-mincho-medium-r-normal--10-100-75-75-m-100-jisx0208.1983-1
	      -jdecw-mincho-medium-r-normal--18-180-75-75-m-180-jisx0208.1983-1     -jdecw-mincho-medium-r-normal--8-80-75-75-m-80-jisx0208.1983-1
	      -jdecw-mincho-medium-r-normal--17-120-100-100-m-170-jisx0208.1983-1				       -jdecw-mincho-medium-r-nor-
	      mal--34-240-100-100-m-340-jisx0208.1983-1 -jdecw-mincho-medium-r-normal--14-100-100-100-m-140-jisx0208.1983-1  -jdecw-mincho-medium-
	      r-normal--25-180-100-100-m-250-jisx0208.1983-1   -jdecw-mincho-medium-r-normal--20-140-100-100-m-200-jisx0208.1983-1  -jdecw-mincho-
	      medium-r-normal--11-80-100-100-m-110-jisx0208.1983-1 JIS X0208 characters (Screen family)

	      -jdecw-screen-medium-r-normal--24-240-75-75-m-240-jisx0208-kanji00				       -jdecw-screen-medium-r-nor-
	      mal--10-100-75-75-m-100-jisx0208-kanji00	-jdecw-screen-medium-r-normal--18-180-75-75-m-160-jisx0208-kanji00 -jdecw-screen-medium-r-
	      normal--16-160-75-75-m-160-jisx0208-kanji00 -jdecw-screen-medium-r-normal--14-140-75-75-m-140-jisx0208-kanji00 -jdecw-screen-medium-
	      r-normal--24-240-75-75-m-240-jisx0208-kanji11    -jdecw-screen-medium-r-normal--10-100-75-75-m-100-jisx0208-kanji11   -jdecw-screen-
	      medium-r-normal--18-180-75-75-m-160-jisx0208-kanji11 -jdecw-screen-medium-r-normal--14-140-75-75-m-140-jisx0208-kanji11

       For printers, the operating system provides only Japanese fonts that are printer-resident; that is, there are no Japanese fonts that can be
       dynamically down-loaded to the printer. Refer to i18n_printing(5) for general information on printing non-English text.

SEE ALSO

       Commands: locale(1)

       Others:	ascii(5),  code_page(5), eucJP(5), i18n_intro(5), i18n_printing(5), iconv_intro(5), iso2022jp(5), Japanese(5), jiskanji(5), sdeck-
       anji(5), shiftjis(5), Unicode(5)

																       deckanji(5)
All times are GMT -4. The time now is 01:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy