Sponsored Content
Top Forums Shell Programming and Scripting match range of different numbers by AWK Post 302340213 by radoulov on Monday 3rd of August 2009 04:52:21 AM
Old 08-03-2009
I was just looking at the last xls ...
Now, first of all, which ranges from input1 you want to compare with the ranges in input2 (column 1 or column 2)?
Isn't the range separator constant or variable (comma, dot or what)?

---------- Post updated at 10:52 AM ---------- Previous update was at 10:29 AM ----------

Quote:
Originally Posted by repinementer
COuld you please explain this one

Code:
  NR == FNR && NF {
  NF > 2 && k = $1
  in2[k] = in2[k] ? in2[k] RS $1 FS $2 : $2 FS $3
  next
  }

Code:
NR == FNR

While reading the first non-empty input file ...

Code:
&& NF

and the current record contains at least one field ...

Code:
NF > 2 && k = $1

if the number of fields is greater than 2 set the variable k to the value of the first field.

Code:
in2[k] = in2[k] ? in2[k] RS $1 FS $2 : $2 FS $3

Build an (associative) array in2 keyed by the current value of k, the values are all first and second fields matching the same key
(simulating a more complex data structure, using the current RS as a element separator).

Code:
next

You need the next statement here, because you don't want these actions to be performed on the next input file(s).
 

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
semanage_port(3)					   Libsemanage API documentation					  semanage_port(3)

NAME
semanage_port - SELinux Network Ports Management API SYNOPSIS
#include <semanage/port_record.h> #include <semanage/ports_policy.h> #include <semanage/ports_local.h> This object contains properties associated with a range of network ports. For details on a specific function, see its manual page. Record API Overview semanage_port_create(3)- create a port range semanage_port_free(3)- release resources for this port range semanage_port_key_create(3)- create a key, which can be used to identify a port range semanage_port_key_free(3)- release resources for this port range key semanage_port_key_extract(3)- create a key matching this port range semanage_port_clone(3)- create an identical port range (deep-copy clone) semanage_port_compare(3)- compare this port range to the provided key semanage_port_compare2(3)- compare this port range to another Properties API Overview semanage_port_get_proto(3)- return the protocol for this port range semanage_port_get_proto_str(3)- return a string representation of the given port protocol semanage_port_set_proto(3)- set the protocol for this port range semanage_port_get_low(3)- return the low port number for this port range semanage_port_get_high(3)- return the high port number for this port range semanage_port_set_port(3)- set the port number (same low and high) for this port range semanage_port_set_range(3)- set the low and high port number for this port range semanage_port_get_con(3)- return the SELinux context for this port range semanage_port_set_con(3)- set the SELinux context for this port range Record Store API Overview semanage_port_modify_local(3)- add or update a port range in the local store semanage_port_del_local(3)- delete a port range from the local store semanage_port_exists(3)- check if a port range is defined in the persistent policy semanage_port_exists_local(3)- check if a port range is defined in the local store semanage_port_query(3)- query a port range in the persistent policy semanage_port_query_local(3)- query a port range in the local store semanage_port_count(3)- count the number of port ranges defined in the persistent policy semanage_port_count_local(3)- count the number of port ranges defined in the local store semanage_port_iterate(3)- execute a callback for each port range in the persistent policy semanage_port_iterate_local(3)- execute a callback for each port range in the local store semanage_port_list(3)- return an array containing all port ranges in the persistent policy semanage_port_list_local(3)- return an array containing all port ranges in the local store ivg2@cornell.edu 16 March 2006 semanage_port(3)
All times are GMT -4. The time now is 03:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy