Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

For loop using 2 files

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers For loop using 2 files
# 1  
Old 01-31-2009
For loop using 2 files
Hi all,

Can anyone shed any light on the following problem?

I have 2 columns in File1:
Code:
10  8                                                
30  44                                               
50  59                                               
94  96                                                  
98  120

and 2 columns in File2:
Code:
25  29
38  41
49  54


File1 and File2 are not even in length.
So my pseudocode is:

Code:
For each line in File2, loop each line in File1
    if Col1 (File2) >= Col1(File1) and Col2(File2) <=Col2(File1)
          Then print File 1 line matching criteria.
End when File2 has reach max length

Outputs should be:

File 1:

Code:
10  8
30  44
94  96

I am happy using awk or sed or grep, but I am having problems with my loops.

Thankyou Smilie

L
Last edited by radoulov; 02-02-2009 at 07:50 AM.. Reason: added code tags
# 2  
Old 01-31-2009
Sorry the tab didnt show well
File 1 is:
Code:
10 8
30 44
50 59
94 96
98 120

File2 is
Code:
25 29
38 41
49 54

Last edited by radoulov; 02-02-2009 at 07:48 AM.. Reason: added code tags
# 3  
Old 01-31-2009
You can try with paste:

Code:
paste file1 file2

# 4  
Old 01-31-2009
Thanx for your reply radoulov's, but your method doesnt relate to my question!
Is anyone else able to help?
Cheers
# 5  
Old 02-01-2009
It only shows that you don't need a loop in this case ...
Is this a homework assignment?
# 6  
Old 02-02-2009
radoulov,

The paste command simply joins the two columns together. I dont see how it can help with the query I have. Secondly, no this is not a homework assignment. I am post doctoral researcher in genetics who is new to programming and in early learning stages.
Cheers.
# 7  
Old 02-02-2009
I apologize,
I did not read your question carefully.
Could you explain your desired output?

Given you sample data for the first conditional we have:

Code:
Col1 (File2) >= Col1(File1) 
25 >= 10

and 

Col2(File2) <=Col2(File1)
29 <= 8

=

false (because of the second condition)

And you say you want to output the first record.
Am I missing something again?
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Loop over files and use awk

Hi, I have a large number of files which are numbered numerically, i.e. of the type 1.usr, 2.usr, 3.usr ... This is what I'd like to do: 1. In ascending order, use awk to read a value from each file. 2. Write this value to another file (say data.txt). This file, 'data.txt' should be... (4 Replies)
Discussion started by: lost.identity
4 Replies

2. Shell Programming and Scripting

awk_Compare two files with a loop

Hi, I have a small query when comparing two files with awk. I have a small piece of code running in a shell. See below: gawk -F"," 'NR == FNR { A=1; next } \!A' OFS="," 2011.csv 2012.csv > diff_2012.csv The code works fine (Note I had to escape the ! with \! to run in shell). What I want... (6 Replies)
Discussion started by: theflamingmoe
6 Replies

3. Linux

rename files using loop with different name

Hi, i need to write a shell script where i have to loop through all the file in a directory and rename them based on below condition. file1.dat file2.dat file3.dat the above files has to be moved to another directory like below file1_201001.dat file2_201002.dat file3_201003.dat... (3 Replies)
Discussion started by: feroz
3 Replies

4. Shell Programming and Scripting

Loop to copy like files

Hi, I need to write a script that copies all .zip files in the subdirectories of ~100 folders. No clue how to write a loop that goes into each folder, searches for a .zip file, and copies it and extracts it to a unique location. I imagine something like cp -f /home/folder1/*.zip... (6 Replies)
Discussion started by: nez
6 Replies

5. Shell Programming and Scripting

loop through files in directory

hi all i have some files present in a directory i want to loop through all the files in the directory each time i loop i should change the in_file parameter in the control file and load it into a table using sql loader there is only one table where i have to load alll the files ... (3 Replies)
Discussion started by: rajesh_tns
3 Replies

6. Shell Programming and Scripting

Grep Different Files Using a Loop?

I have a script to GREP for a text expression within certain files, the files being named file.11012008 thru file.11302008. 30 files in all, one for each day of the month. Instead of entering the following 3 lines of code 30 different times, I'm trying to find a way to loop the process: ... (6 Replies)
Discussion started by: foleyml
6 Replies

7. Shell Programming and Scripting

reading from 2 files through while loop

hi i have two files cat input.txt 123456| 43256 456482|5893242 cat data.txt xv 123456 abcd dsk sd 123456 afsfn dd df 43256 asdf ff ss 456482 aa sf 5893242 ff ff aa 5893242 aa aa i need to read inputs from input.txt and find data for data.txt. then i need to print them as a... (2 Replies)
Discussion started by: windows
2 Replies

8. UNIX for Dummies Questions & Answers

Loop through files

Hi, I'm trying loop through all files in a directory that have a filename starting with 'CC', and process them one by one. Can any provide an example of how I could do this. I've started with: if test -f CC* then #add files to an array #loop through array and process the file based on... (1 Reply)
Discussion started by: kshelluser
1 Replies

9. Shell Programming and Scripting

Loop through files in a directory

Hi, I want to write bash script that will keep on looking for files in a directory and if any file exists, it processes them. I want it to be a background process, which keeps looking for files in a directory. Is there any way to do that in bash script? I can loop through all the files like... (4 Replies)
Discussion started by: rladda
4 Replies
Login or Register to Ask a Question