Sponsored Content
Top Forums Shell Programming and Scripting match range of different numbers by AWK Post 302339377 by repinementer on Thursday 30th of July 2009 10:48:57 AM
Old 07-30-2009
Quote:
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

Code:
C1 	32 	36

	50 	55

	86 	88

C1	2       3

	4   55

	86	88

Input 2
Code:
c1 	5 	10

output
Code:
C1 	32 	36     BRANGE

	50 	55 	

	86 	88 	

C1 	2 	3 	GRANGE

	4      55 	

	86 	88

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..
 

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
CURLOPT_RANGE(3)					     curl_easy_setopt options						  CURLOPT_RANGE(3)

NAME
CURLOPT_RANGE - set byte range to request SYNOPSIS
#include <curl/curl.h> CURLcode curl_easy_setopt(CURL *handle, CURLOPT_RANGE, char *range); DESCRIPTION
Pass a char * as parameter, which should contain the specified range you want to retrieve. It should be in the format "X-Y", where either X or Y may be left out and X and Y are byte indexes. HTTP transfers also support several intervals, separated with commas as in "X-Y,N-M". Using this kind of multiple intervals will cause the HTTP server to send the response document in pieces (using standard MIME separation techniques). Unfortunately, the HTTP standard (RFC 7233 section 3.1) allows servers to ignore range requests so even when you set CURLOPT_RANGE(3) for a request, you may end up getting the full response sent back. For RTSP, the formatting of a range should follow RFC2326 Section 12.29. For RTSP, byte ranges are not permitted. Instead, ranges should be given in npt, utc, or smpte formats. Pass a NULL to this option to disable the use of ranges. The application does not have to keep the string around after setting this option. DEFAULT
NULL PROTOCOLS
HTTP, FTP, FILE, RTSP and SFTP. EXAMPLE
CURL *curl = curl_easy_init(); if(curl) { curl_easy_setopt(curl, CURLOPT_URL, "http://example.com"); /* get the first 200 bytes */ curl_easy_setopt(curl, CURLOPT_RANGE, "0-199"); /* Perform the request */ curl_easy_perform(curl); } AVAILABILITY
FILE since 7.18.0, RTSP since 7.20.0 RETURN VALUE
Returns CURLE_OK on success or CURLE_OUT_OF_MEMORY if there was insufficient heap space. SEE ALSO
CURLOPT_RESUME_FROM(3), libcurl 7.54.0 December 21, 2016 CURLOPT_RANGE(3)
All times are GMT -4. The time now is 02:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy