12-09-2009
Looping through 2 files simultaneously
Hi all,
I'm having a problem with a script which should ultimately provide a filename by reading a value from file1 and file2 then join together.
I'm planning to use a loop/ loops to get the values out of both files and create a single string unfortunately the code currently treats the second loop (which is how I have written it to be fair) as nested instead of working simultaneously. The thing is that my sanity is slowly slipping away so I have stripped the code back to try and get a clearer picture.
The file's contain:
num.txt
65
65
66
67
first.txt
MRO0122
MRO0112
MRO0112
MRO0113
Currently the code returns:
MRO011365
MRO011365
MRO011366
MRO011367
What I want is
MRO012265
MRO011265
MRO011266
MRO011367
Anyway here's the code:
for update in `cat num.txt`
do
echo $update
for filename1 in `cat first.txt`
do
echo $filename1
truefile=$filename1$update.TXT
done
echo $truefile
doneLet me know if this is post is confusing in it's description and i'll try to provide clearer detail.
Any help will be thoroughly appreciated
I'm off to shoot myself.
Thanks
Chris
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Okay...
I've solved one problem.
Here's the next.
I'm writing a script file that needs to go through a directory and list all files in that directory.
I'm using TCL/TK.
I figured out how to go through the directory and how to loop through it, but I ran into a little problem.
... (2 Replies)
Discussion started by: kapolani
2 Replies
2. Shell Programming and Scripting
Say I have 2 files of 2 rows of 3 columns each
file1:
cat catdata1 catdata2
dog dogdata1 dogdata2
file2:
cat catdata3 catdata4
dog dogdata3 dogdata4
and I need to combine both files so that is appears like:
cat catdata1 catdata2 catdata3 catdata4
dog dogdata1 dogdata2 dogdata3... (8 Replies)
Discussion started by: Awanka
8 Replies
3. Shell Programming and Scripting
I posted this in the Solaris forum, but I don't think it's platform specific, so I'm posting it here.
Here is the situation. We are a company that has been using a professional publishing system, the software is called "ProType". It runs on Solaris 2.4, however it is no longer supported and we... (6 Replies)
Discussion started by: Fred Goldman
6 Replies
4. Shell Programming and Scripting
I can't get touch to simultaneously create three empty files file1, file2, file3. I tried:$ touch filebut all I got was one file:$ fileWhat did I do wrong? (4 Replies)
Discussion started by: na5m
4 Replies
5. Shell Programming and Scripting
Hi,
I am having issue where I have to tail 3 log files continuously (forever) and while I am reading the files , parse them and shove the data into DB. I can do this with one file totally fine but how can I read 3 files at the same time? I am not really looking for code (but would be nice) but... (3 Replies)
Discussion started by: Dabheeruz
3 Replies
6. Shell Programming and Scripting
Hi ,
I have a large no of files which all end in .asp.htm extension .
But for proper navigation between the pages I need to rename all those files as .asp only .
How can it be done ? (4 Replies)
Discussion started by: nshailesh
4 Replies
7. Shell Programming and Scripting
I am writing a ksh which has to load 7 files(.dat files) from input directory into oracle tables using sql loader. The process has to take each file at a time and once if it is loaded succesfully using sql loader into oracle tables then the process has to pick next file and load it into oracle... (2 Replies)
Discussion started by: vpv0002
2 Replies
8. UNIX for Dummies Questions & Answers
Does anybody know how to make symbolic links for multiple files simultaneously?
Often times I need make symbolic links for multiple files with some common pattern (just like "*.jpg"). Is there a way to avoid making symbolic link for each of them one by one...
Thank you! (6 Replies)
Discussion started by: danieladna
6 Replies
9. Shell Programming and Scripting
Hello,
Is it possible to handle data from two different files at once in awk (latest version and platform is Fedora). I found on the net that we cannot nest awk. My requirement is that I have two similar files :
File 1:
Name: abc
Val = 58
Name: cdf
Val = 1;
..................
File... (7 Replies)
Discussion started by: fifteate
7 Replies
10. Shell Programming and Scripting
dear all,
i'm preparing a script which can do these actions :
1. stop remove server's certain service
2. clean the files on remote servers simultaneously (because lots of files need to be deleted)
3. after files/logs are removed, restart the service again
i'm stuck on how to clean remote... (4 Replies)
Discussion started by: tiger2000
4 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specifed in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
JOIN(1)