loop through two files based on a variable


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting loop through two files based on a variable
# 1  
Old 02-23-2009
loop through two files based on a variable

Hi guyz. i have two files. based on keys(chr1, chr2..) it has to loop through the second file of the same keys and has to take the minimum number after substraction. Sorry if I made my question complicated.

file1
chr2 1989
chr2 2500
chr1 1500

file 2
chr1 1339
chr2 2000
chr2 3000
chr2 1200
chr1 1600
chr2 4000

output
chr2...1989.....2000
chr2...2500.....3000
chr1...1500.....1600
# 2  
Old 02-23-2009
find smallest distance between numbers in arrays

Hi,

do someone know, How we can find the smallest distance between values of different columns?
Like I have column1 & column2.
-73.924598,40.879010
-73.924506,40.878978
-73.924506,40.878978
-73.921406,40.878178
-73.921406,40.878178
-73.920806,40.878578
-73.920206,40.878978
-73.920206,40.878978
-73.918706,40.876578
-73.918706,40.876578

If I want to see, which one is closer to the first point in 1st column among all the points in second column and so on??
How should I do?
# 3  
Old 02-23-2009
perl script sub routine

hi I have bee trying to print the closest numbers in 2 arrays @set and @vals but the script i'm using giving the output only for 1st no in 1st array i.e 15 with all values in array2. I'm getting output 56 only. I need the values close to 150,200 and 250. Is there any thing wrong with the script.
Sorry If my question is perplexing

the script I'm using

#!usr/bin/perl
use strict;
use warnings;

my @set = (15, 150, 200, 250);
my @vals = (208, 258, 56, 123);

print closest(@set, @vals), "\n";

sub closest {
my $val = shift;
my @list = sort { abs($a - $val) <=> abs($b - $val) } @_;
$list[0];
}
# 4  
Old 02-23-2009
All your code is doing is sorting a flattened list. Since 56 is the lowest number of the sorted list thats what gets returned. But after reading your post I can't figure out what it is you are actually wanting to do. Can you clarify?
# 5  
Old 02-23-2009
sorting the columns should be the way to go.
# 6  
Old 02-23-2009
ya u r right but i need the way to claculate it
# 7  
Old 02-23-2009
NO
but i do agree my question needs more explanation
If i change the values in @set to only one number like 200 it gives the output as 208,closest number of 200
when I tried the script with only one value it is working properly.
I want to extract the closest numbers from set of values in column1 with column2 . the value 3 in column1 has to sort all the values in column2 (4,6,8,1) and gives the closest number i.e,4 and vice versa.
the crux is each value of column1 hat to sort all the values in column2
I wasted 2 days for this it would be really grateful if u answer this

3....4
4....6
......8
......1

output
3.....4
4.....6
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Compare two files and print based on common variable value.

Hi All, i have below two files. FILE: NAME="/dev/sda" TYPE="disk" SIZE="60G" OWNER="root" GROUP="disk" MODE="brw-rw----" PKNAME="" MOUNTPOINT="" NAME="/dev/sda1" TYPE="part" SIZE="500M" OWNER="root" GROUP="disk" MODE="brw-rw----" PKNAME="/dev/sda" MOUNTPOINT="/boot" NAME="/dev/sda2"... (3 Replies)
Discussion started by: balu1234
3 Replies

2. Shell Programming and Scripting

Naming output files based on variable parameters and input filenames

Hello, I have a series of files in sub-directories that I want to loop through, process and name according to the input filename and the various parameters I'm using to process the files. I have a number of each, for example file names like AG005574, AG004788, AG003854 and parameter values like... (2 Replies)
Discussion started by: bdeads
2 Replies

3. Shell Programming and Scripting

Calling a Variable based on a Variable

Hi all, I have a source config file with variables like so: eth1_ip=192.168.1.99 eth2_ip=192.168.1.123 eth3_ip=172.16.1.1 I am trying to run a script which loops based on the number of eth interfaces on a machine and therefore modifies the variable it calls in the environment based on the... (5 Replies)
Discussion started by: landossa
5 Replies

4. Shell Programming and Scripting

[Solved] How to increment and add variable length numbers to a variable in a loop?

Hi All, I have a file which has hundred of records with fixed number of fields. In each record there is set of 8 characters which represent the duration of that activity. I want to sum up the duration present in all the records for a report. The problem is the duration changes per record so I... (5 Replies)
Discussion started by: danish0909
5 Replies

5. Shell Programming and Scripting

Array Variable being Assigned Values in Loop, But Gone when Loop Completes???

Hello All, Maybe I'm Missing something here but I have NOOO idea what the heck is going on with this....? I have a Variable that contains a PATTERN of what I'm considering "Illegal Characters". So what I'm doing is looping through a string containing some of these "Illegal Characters". Now... (5 Replies)
Discussion started by: mrm5102
5 Replies

6. Shell Programming and Scripting

printing variable with variable suffix through loop

I have a group of variables myLINEcnt1 - myLINEcnt10. I'm trying to printout the values using a for loop. I am at the head banging stage since i'm sure it has to be a basic syntax issue that i can't figure out. For myIPgrp in 1 2 3 4 5 6 7 8 9 10; do here i want to output the value of... (4 Replies)
Discussion started by: oly_r
4 Replies

7. Shell Programming and Scripting

[SHELL: /bin/sh] For loop using variable variable names

Simple enough problem I think, I just can't seem to get it right. The below doesn't work as intended, it's just a function defined in a much larger script: CheckValues() { for field in \ Group_ID \ Group_Title \ Rule_ID \ Rule_Severity \ ... (2 Replies)
Discussion started by: Vryali
2 Replies

8. Shell Programming and Scripting

Using awk to create files based on a variable name

Hey all, I am parsing a file which have records containing one of a number of files names: ".psd", ".cr2", ".crw" , ".cr", ".xi", ".jpg", ".xif" etc Somewhere on each line there is a value "Namex.psd" "Namex.crw" etc. The position of this name is highly variable I need to output all the ".psd"... (4 Replies)
Discussion started by: C0ppert0p
4 Replies

9. Shell Programming and Scripting

create variable name based on another variable's value

Hello, I am needing to create a variable and assign it a value based on the value of a previosly defined variable... I am using KSH.. Example: VAR1=COMPUTER1 I need another variable like ${VAR1}_FLAG="Y", so it would actually be COMPUTER1_FLAG="Y". I will be looping through many values in... (2 Replies)
Discussion started by: benefactr
2 Replies
Login or Register to Ask a Question