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

iptunnel

iptunnel(8)						      System Manager's Manual						       iptunnel(8)

NAME

       iptunnel - Creates, deletes, and displays configured tunnels

SYNOPSIS

       /usr/sbin/iptunnel  [operation] [args]

DESCRIPTION

       The  iptunnel  command creates configured tunnels for sending and receiving IPV6 or IPV4 packets that are encapsulated as the payload of an
       IPV4 datagram.

       The iptunnel command can perform one of the following operations: Creates a tunnel interface, which  you  must  subsequently  configure	by
       using the ifconfig command. The syntax of the create operation is as follows:

	      iptunnel create [-I int-name] [v4-dest] [v4-src]

	      Specifies  the  interface unit of the tunnel to be created. This is an optional parameter.  The int-name parameter has the following
	      form: iptx, where x is the interface unit number. By default, the interface name selected for the tunnel is iptx+1, or the value	of
	      the  interface  unit  number  of the last tunnel created plus 1.	Specifies the remote end-point to which a tunnel is to be created.
	      Sets the IPV4 source address in the encapsulating header.  The tunnel is enabled (packets are sent/received on the tunnel)  only	if
	      v4-src  is  a valid address on the system.  This is an optional parameter.  Deletes a tunnel interface.  You must disable the tunnel
	      before you can delete it by executing the following command: # ifconfig tunnel name down	delete abort Shows the	tunnel	attributes
	      (name, tunnel end points, next hop for tunneled packets).

EXAMPLES

       To create a tunnel from hobbes to calvin, enter: # iptunnel create -I ipt5 calvin  ipt5  iftype 208 src 16.140.16.86 dst 16.140.16.91

       To display the tunnel attributes, enter: # iptunnel show ipt5 interface ipt5 src 16.140.16.86 dst 16.140.16.91 gate 16.140.16.86 To config-
       uring the tunnel to encapsulate IPv6 packets, enter: # ifconfig ipt5 ipv6 up

	      IPv6 packets will be sent as payloads of IPv4 datagrams from 16.140.16.86 to 16.140.16.91.

	      The tunnel may also be used to send IPV4 packets encapsulated within IPV4 headers as follows: # ifconfig	ipt5  10.10.80.60  netmask
	      255.255.255.0

	      To verify the previous command, enter: # ifconfig ipt5 ipt5: flags=4c1<UP,RUNNING,NOARP,MULTICAST>
		   16.140.16.86 --> 16.140.16.91
		   rxmt 1000, reach time 30000, dad tries 1, mtu 1280, hops 64, token len 64
		   inet 10.10.80.60 netmask ffffff00  ipmtu 1280
		   inet6  fe80::108c:1056  To  deleting the tunnel, enter: # ifconfig ipt5 down delete abort ipt5: delete inet address 10.10.80.60
	      10.10.80.60: aborting 0 tcp connection(s)

	      Then, enter: # iptunnel delete ipt5 interface ipt5 deleted

SEE ALSO

       Commands: ifconfig(8).

       RFC 2003, IP Encapsulation within IP, Perkins, C., October 1996

																       iptunnel(8)
All times are GMT -4. The time now is 03:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy