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 302340711 by repinementer on Wednesday 5th of August 2009 05:21:57 AM
Old 08-05-2009
Hi Rado
Ya. Now it's working great.
Yesterday and today I completely spend my time reading AWK book.
I covered up to control statements. Still your script is looking complex to me though I'm able to understand somepart.
But your are right in one thing I'm learning so much even though it is taking lot of time.

Thanx for the help and suggestionsSmilie

---------- Post updated at 09:23 PM ---------- Previous update was at 04:32 AM ----------


Input
Code:
X1	84	140	-	4,10,4	0,36,52
X1	20	110	+	5,10,5	0,35,90
X1	84	140	-	4,10,4	0,36,52

output
Code:
X1	136 140		84	140	-	4,10,4	0,36,52
  	120 130
  	84 88

X1	20 25		20	110	+	5,10,5	0,35,90
  	55 65
  	110 115

  	136 140
X1	120 130		84	140	-	4,10,4	0,36,52
  	84 88
X1	136 140		84	140	-	4,10,4	0,36,52
  	120 130
  	84 88

Needed and correct output

Code:
X1	136 140		84	140	-	4,10,4	0,36,52
  	120 130
  	84 88

X1	20 25		20	110	+	5,10,5	0,35,90
  	55 65
  	110 115
X1	136 140		84	140	-	4,10,4	0,36,52
  	120 130
  	84 88

Some where in the code is printing double values for "-".
The bold letters are creating mess. As you can see X1 is one row down as well as its unnecessary duplicate

---------- Post updated 08-05-09 at 01:21 AM ---------- Previous update was 08-04-09 at 09:23 PM ----------

I solved it. Please don't post any answer for this question

Code:
$ awk 'NF {
  sec = $2; fifth = split($5, _fifth, ","); sixth = split($6, _sixth, ",")
  counter = rec = ""; key = $1; flag = $4; sub(/[^ \t*]*/, "")
  dummy = sprintf("%*s", length(key),x)
  for (i=1; i<=sixth; i++) {
    second_third = sec + _sixth[i] FS _fifth[i] + sec + _sixth[i]
    third_second = sec + _sixth[i] FS _fifth[i] + sec + _sixth[i]
    if (flag == "+")
      rec = rec ? rec RS dummy OFS second_third : key OFS second_third OFS $0
    else if (flag == "-")
      rec = rec ? rec RS dummy OFS third_second : key OFS third_second OFS $0
  }
  print (flag == "+" ? rec : rec)
  }' OFS='\t' ORS='\n\n' input.txt

Last edited by repinementer; 08-05-2009 at 04:29 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 05:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy