merge file with nearest range !!!!!!!


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting merge file with nearest range !!!!!!!
# 1  
Old 02-10-2009
merge file with nearest range !!!!!!!

I want join 2 files with range of numbers in ascending order according to the value of the numbers the input will be like this

INPUT

file1
column1 column2
10 14
20 25
56 58
83 90
FILE 2
column1 column 2
1 2
2 8
10 14
20 24
50 58
60 63
70 76
80 100

OUTPUT
col1 col2 col3 col4
1 2
2 8
10 14 10 14
20 25 20 24
56 58 50 58
70 76
83 90 80 100
# 2  
Old 02-10-2009
merge file with nearest range !!!!!!!

I want join 2 files with range of numbers in ascending order according to the value of the numbers the input will be like this

INPUT

file1
column1 column2
10 14
20 25
56 58
83 90
FILE 2
column1 column 2
1 2
2 8
10 14
20 24
50 58
60 63
70 76
80 100

OUTPUT
col1 col2 col3 col4
1 2
2 8
10 14 10 14
20 25 20 24
56 58 50 58
70 76
83 90 80 100
# 3  
Old 02-10-2009
Help would be appreciated
# 4  
Old 02-10-2009
any help would be appreciated
# 5  
Old 02-10-2009
If you search the forum one of your colleague just ask a similar question few days ago Smilie
# 6  
Old 02-11-2009
finding nearest numbers

Hey guys I would like to know how to find nearest numbers based on second column in 1st column some thing like this

Input
col1 col2
10 20
30 40
48 64
55 71
70 90

output
col1 col2 col3
10 20 30
30 40 48
48 64 70
55 71
70 90
# 7  
Old 02-11-2009
I need col 3
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Checking File record equal to multiple of 70 or nearest number to multiple of 70

Hello, I have a file with below content - Example 3 6 69 139 210 345 395 418 490 492 I would like the result as - Multiple of 70 or nearest number in the file less than the multiple of 70 69 139 (5 Replies)
Discussion started by: Mannu2525
5 Replies

2. Shell Programming and Scripting

Match and Grep the nearest value in last field

Gents I have this input file file1 (uniq records) 54503207851 170211240 54503207911 170210837 54503208111 170215105 54503208112 170215210 54655210011 170223140 54655210091 170223738 54655210172 170224355 54655210251 170224741 54655210331 170225039 54655210411 170225505 54655210492... (13 Replies)
Discussion started by: jiam912
13 Replies

3. Shell Programming and Scripting

Selecting nearest pattern match

I'm looking to match an error code against a list of possible codes and get the nearest match. The code would be a 6 character hexadecimal string. I have a file of error codes all of which have a specific first 3 characters, however, after that the last 3 characters may be specific or generic as... (3 Replies)
Discussion started by: dazedandconfuse
3 Replies

4. Shell Programming and Scripting

Rounding off to the nearest floating number

I have a number, which I want to convert into the nearest floating number upto two places after the decimal point. E.g. 1.2346 will become 1.23 but 1.2356 will become 1.24 . Similarly 0.009 will be 0.01 and 0.001 will be 0.00 or 0.0 (not 0, wnat to keep the decimal... (1 Reply)
Discussion started by: hbar
1 Replies

5. UNIX for Dummies Questions & Answers

Rounding up to nearest whole number

Hi all of you, Would be great if you help me with how to round up to whole number from my input values like 2.99996,2.17890,3.00002,-2.3456,-2.7890 o/p should be like 3,2,3,-2,-3 thnks in adv!!!! regards (3 Replies)
Discussion started by: Indra2011
3 Replies

6. Shell Programming and Scripting

Grep the nearest value from a csv file to another

Hello, I have two csv file. The first one (a huge file) with 3 columns X, Y, Z The second one with 2 columns A, B All the values are numbers. I need to parse every "Z" field of the first file, find the closest "B" value in the second and extract from it the "A" relative value, to... (5 Replies)
Discussion started by: rjval
5 Replies

7. Homework & Coursework Questions

Need Help, How to round off to the nearest 5 sen?

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data:#include <stdio.h> #define GTAX 0.06 #define STAX 0.10 int main(void) { int C_sets; double Price_C; ... (1 Reply)
Discussion started by: pwmk
1 Replies

8. UNIX for Dummies Questions & Answers

finding nearest value in a column

Hi, I have 2 files: file1: 1 ia 2 1 mn 6 1 sd 11 2 ny 3 2 ma 10 3 wa 7 3 ca 8 file2 1 mi 3 1 wi 5 2 pa 4 3 id 6 (2 Replies)
Discussion started by: peanuts48
2 Replies

9. UNIX for Dummies Questions & Answers

match nearest

Hi, I'm trying to find the nearest match between two columns of numbers, e.g. 1,1 10,8 30,50 20,100 and the search could be e.g. 20,20 returning 10,8 - i.e. 20-10 = 10 and 20-8 = 12 totalling 22, and hence being the nearest match. any ideas? thanks a lot, (1 Reply)
Discussion started by: bogu0001
1 Replies

10. Shell Programming and Scripting

Urgent help on grep the nearest value

Hi, I have a list of data in text files with :- ColA ColB ColC ColD ColE ColF 12 122 2280 30 0.012987 1.776 13 118 2280 30 0.012987 1.954 14 115 2620 30 0.011321 2.131 15 113 2654 30 0.011177 2.309 16 145 1882 25 0.013110 2.487 17 112... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
Login or Register to Ask a Question