Search Results

Hey sorry for the troule
A small query. Where do I need to change the script for the following input(New kind of input(2ndone) in this every value at the end ends with additional comma)

Old-input...

O.k Seems to be the code is completely with perfectionism :-).I have updated and modified little bit. This script is officially over. Thanx for your kind support.


#!/usr/bin/awk -f

BEGIN {...

Hey is that it. My god you don't believe how much time I spent on this script. Thank you for still considering my long time boring queries and answering. Anyways coming to the point......


But...

input1


A 239861347 239858777 -
B 233849110 233849388 +
C 202864284 202864396 +
D 187984662 187982263 -
input2


A 239858789 239865855 -
B 233849110 233849388 +
C 202864284 202864396 +...

Can I do some thing like this. ???But I modifed according to my requirements.

#!/usr/bin/awk -f

BEGIN {
OFS="\t"; ORS="\n"
def["ascoutlower"] = "ARANGE"
def["ascoutupper"] =...

I dont understand. Anyways Thanx for the advice

Hey rado there is only one change left. Could you help me with this.
input1

A1 1 2 +
A1 2 4 +
A2 120 130 +
A2 136 140 +
A3 2 1 -
A3 4 2 -
A4 ...

.
.
.
.
.

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

Because in ARANGE 1,2 and 2,4 of X1are out of area when they compared to the ranges
5-10,30-40,80-90 and 100-118.


.....5-10,30-40,80-90 and 100-118 ARANGE
1-2,2-4
In second case GRANGE, ...

Now, first of all, which ranges from input1 you want to compare with the ranges in input2 (column 1 or column 2)?

It has to be column2 or 3 because column 1 has keys like X1....X2...
Now, first...

COuld you please explain this one

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

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

Thanx

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

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

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.

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 have gone through your code.
I have understood how you differentiated and assigned "desc", "asc", "in", "out", "lower", "upper", "exact", "inexact" of input 1 first range value and how you set...

Yes I did. But I did it on purpose. But you are right I should give the same names to same type of ranges. Anyways.I 'm reading arrays in awk now. The book is really helping me alot.

Could you...

Thanx Rado
Working fine now

---------- Post updated at 02:13 AM ---------- Previous update was at 01:26 AM ----------

Is it possible to modify the script for the problem I have posted earlier...

I have a made a small correction in the second script you made (sec = $2) as per my need. Every thing working fine but it printing 2 times if the flag is "-" and working fine with "+"

Could you...

Thank you very much for your great scripts:)

I did the exercise. The book u referred is really really good. Now on my own created couple of super scripts :p but compare to yours nothing.

But I...

YAAAA. Sorry DA
Thst why I mentioned in Bold :-(

---------- Post updated at 02:07 AM ---------- Previous update was at 02:05 AM ----------

The book you have suggested is really Awesome.
Thanx

Well the low bound values adds with 5,10,15,10,20 and produce upperbound



+ 5,10,15,10,20 0,25,40,75,95

5 + 0 = 5
5 + 25 = 30
5 + 40 = 45
and so on...

5 + 5 = 10
30 +10 = 40
45...

First of all I have to say sorry for errors in posting. Please excuse me for this time. You are right about the errors.

I'm including new inputs

INPUT1


...