Shell Programming and Scripting

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


Could you try to elaborate further on the difference between the E/F and G/H ranges?

Actually what I'm trying to modify is

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

Hey rado I'm including a simple figure and simpler values that elaborates my modifications.
Hope this helps. And don't forget the values I used in this figure are different from the XLS file.

OK,
now I understand the definition of G/H ranges. I need more info (or a sample) on how the actual output should look like.
Do you want to combine both results (the second one - ranges from input1 with their definitions - appended
after the first one - ranges from input2 with definitions, for example)?

I have uploaded an excel file that has 3 worksheets including input1, input2 and desired output.

Based on the input2 value signs (positive or negative) ranges of output are given.
If its positive sign it is exactly as I mentioned in the previous picture.
If its negative sign there will be little change.

For understanding this I'll include another picture

Thanx

The figure that explains comparison of ranges of specific keys based on positive and negative signs

I hope you understood what I previously posted.
But post if you don't understand any

Thanx