The script I posted compares the ranges in the file input2 with all the ranges
for the relative key in file input1 (not only the first one).
Actually what I'm trying to modify is
Quote:
The script I posted has to compare all the ranges in the file input1 with all the ranges
for the relative key in file input2 and then decide the RANGE(not only the first one).
####################################################
Anyways coming to the point
I mean the ranges in bold letters (We only compared the 1st range i.e, 32-36). But I would like to compare all the ranges of specific key like32-36,50-55 and 86-88
If c1 ranges(all) like 32-36, 50-55 and 86-88 are out of the ranges (all) of input2 like 5-10 then we will give range name (In this case Brange)
Like the above 2ndone has 2-3,4-55 and 86-88. In this case 2-3 range is out of range it comes under ARANGE according the previous script. But now we have to consider all the ranges 2-3,4-55 and 86-88. If any one is overlapping with the ranges it comes under G or H range according the lower or upper values. In this case 4-55 overlapping with 5-10 and it comes under GRANGE
Example:
Input 1
Input 2
output
In the previous post of excel file I have mentioned different types of varieties overlapping with values. Simply I placed all overlapping values
under either GRANGE (If they are lower) or HRANGE (If they are upper).
The main thing modified is comparing not only the first range of a key value but also all the ranges of key value and basing on the all the ranges we decide which range they belong
I assume you will understand now.
In case you are not I will explain more elaborately each range individually. Please let me know. I 'll get back to you asap.
Please don't hesitate to criticize me or advice me.
You helped me alot by suggesting AWK book. I'm practicing it daily.I'm really amazed by its built in variables like NR, FNR, OFS,FS. Awk is really awesome.
Thanx rado
Last edited by repinementer; 07-30-2009 at 11:57 AM..
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)
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)
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)
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)
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)
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)
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 SUSE
net::cidr::lite
Lite(3) User Contributed Perl Documentation Lite(3)NAME
Net::CIDR::Lite - Perl extension for merging IPv4 or IPv6 CIDR addresses
SYNOPSIS
use Net::CIDR::Lite;
my $cidr = Net::CIDR::Lite->new;
$cidr->add($cidr_address);
@cidr_list = $cidr->list;
@ip_ranges = $cidr->list_range;
DESCRIPTION
Faster alternative to Net::CIDR when merging a large number of CIDR address ranges. Works for IPv4 and IPv6 addresses.
METHODS
new()
$cidr = Net::CIDR::Lite->new
$cidr = Net::CIDR::Lite->new(@args)
Creates an object to represent a list of CIDR address ranges. No particular format is set yet; once an add method is called with a
IPv4 or IPv6 format, only that format may be added for this cidr object. Any arguments supplied are passed to add_any() (see below).
add()
$cidr->add($cidr_address)
Adds a CIDR address range to the list.
add_range()
$cidr->add_range($ip_range)
Adds a hyphenated IP address range to the list.
add_cidr()
$cidr1->add_cidr($cidr2)
Adds address ranges from one object to another object.
add_ip()
$cidr->add_ip($ip_address)
Adds a single IP address to the list.
add_any()
$cidr->add_any($cidr_or_range_or_address);
Determines format of range or single ip address and calls add(), add_range(), add_cidr(), or add_ip() as appropriate.
$cidr->clean()
$cidr->clean;
If you are going to call the list method more than once on the same data, then for optimal performance, you can call this to purge null
nodes in overlapping ranges from the list. Boundary nodes in contiguous ranges are automatically purged during add(). Only useful when
ranges overlap or when contiguous ranges are added out of order.
$cidr->list()
@cidr_list = $cidr->list;
$list_ref = $cidr->list;
Returns a list of the merged CIDR addresses. Returns an array if called in list context, an array reference if not.
$cidr->list_range()
@cidr_list = $cidr->list_range;
$list_ref = $cidr->list_range;
Returns a list of the merged addresses, but in hyphenated range format. Returns an array if called in list context, an array reference
if not.
$cidr->list_short_range()
@cidr_list = $cidr->list_short_range;
$list_ref = $cidr->list_short_range;
Returns a list of the C subnet merged addresses, in short hyphenated range format. Returns an array if called in list context, an array
reference if not.
Example:
1.1.1.1-2
1.1.1.5-7
1.1.1.254-255
1.1.2.0-2
1.1.3.5
1.1.3.7
$cidr->find()
$found = $cidr->find($ip);
Returns true if the ip address is found in the CIDR range. False if not. Not extremely efficient, is O(n*log(n)) to sort the ranges in
the cidr object O(n) to search through the ranges in the cidr object. The sort is cached on the first call and used in subsequent
calls, but if more addresses are added to the cidr object, prep_find() must be called on the cidr object.
$cidr->bin_find()
Same as find(), but forces a binary search. See also prep_find.
$cidr->prep_find()
$cidr->prep_find($num);
Caches the result of sorting the ip addresses. Implicitly called on the first find call, but must be explicitly called if more
addresses are added to the cidr object. find() will do a binary search if the number of ranges is greater than or equal to $num
(default 20);
$cidr->spanner()
$spanner = $cidr1->spanner($label1, $cidr2, $label2, ...);
Creates a spanner object to find out if multiple ip addresses are within multiple labeled address ranges. May also be called as (with
or without any arguments):
Net::CIDR::Lite::Span->new($cidr1, $label1, $cidr2, $label2, ...);
$spanner->add()
$spanner->add($cidr1, $label1, $cidr2, $label2,...);
Adds labeled address ranges to the spanner object. The 'address range' may be a Net::CIDR::Lite object, a single CIDR address range, a
single hyphenated IP address range, or a single IP address.
$spanner->find()
$href = $spanner->find(@ip_addresses);
Look up which range(s) ip addresses are in, and return a lookup table of the results, with the keys being the ip addresses, and the
value a hash reference of which address ranges the ip address is in.
$spanner->bin_find()
Same as find(), but forces a binary search. See also prep_find.
$spanner->prep_find()
$spanner->prep_find($num);
Called implicitly the first time $spanner->find(..) is called, must be called again if more cidr objects are added to the spanner
object. Will do a binary search if ratio of the number of ip addresses to the number of ranges is less than $num percent (default 4).
$spanner->clean()
$clean_address = $spanner->clean($ip_address);
Validates and returns a cleaned up version of an ip address (which is what you will find as the key in the result from the
$spanner->find(..), not necessarily what the original argument looked like). E.g. removes unnecessary leading zeros, removes null
blocks from IPv6 addresses, etc.
CAVEATS
Garbage in/garbage out. This module does do validation, but maybe not enough to suit your needs.
AUTHOR
Douglas Wilson, <dougw@cpan.org> w/numerous hints and ideas borrowed from Tye McQueen.
COPYRIGHT
This module is free software; you can redistribute it and/or
modify it under the same terms as Perl itself.
SEE ALSO
Net::CIDR.
perl v5.12.1 2010-03-26 Lite(3)