Hi,
I have two files that I need to combine, as the combined tables need to be read into a programme.

1st table is shots (046)
comp/sc046sh001_comp.%04d.dpx
comp/sc046sh002_comp.%04d.dpx
comp/sc046sh003_comp.%04d.dpx

2nd Table (046scene_config)
1,0000,0
2,0001,0121,121
3,0001,0111,232

The second table is the record-in value for each shot on a timeline.

#! /bin/tcsh -f
foreach i ( `cat 046` )
foreach j ( `cat /sc046_config | awk 'BEGIN { FS = "[,]" } ; { print $4 } '`)
echo $i $j
end
end

The results are:
comp/sc046sh001_comp.%04d.dpx 0
comp/sc046sh001_comp.%04d.dpx 121
comp/sc046sh001_comp.%04d.dpx 232
comp/sc046sh001_comp.%04d.dpx 300
comp/sc046sh002_comp.%04d.dpx 0
comp/sc046sh002_comp.%04d.dpx 121
comp/sc046sh002_comp.%04d.dpx 232
comp/sc046sh002_comp.%04d.dpx 300
comp/sc046sh003_comp.%04d.dpx 0
comp/sc046sh003_comp.%04d.dpx 121
comp/sc046sh003_comp.%04d.dpx 232
comp/sc046sh003_comp.%04d.dpx 300

What I am trying to achieve is:
comp/sc046sh001_comp.%04d.dpx 0
comp/sc046sh002_comp.%04d.dpx 121
comp/sc046sh003_comp.%04d.dpx 232
comp/sc046sh004_comp.%04d.dpx 300

So the first line of the first table relates to the first line of the second table, and this continues down until the end. How do I stop it looping around, so that each line of the first table does every line of the second table.

Any help much appreciated.

Thanks

Matt.

There is a command "paste" that will do this for you without needing foreach loops.

Either...

awk -F\, '{print $4}' sc046_config > TEMP
paste 046 TEMP > NEWFILE

or...

paste 046 `awk -F\, '{print $4}' sc046_config` > NEWFILE

John

Another way, which might be a bit longer...

First figure out how many lines are in the first file (add one to this for the loop later):

let howLong=`cat (046)|wc -l`+1

Then walk through the files joining the lines together
let lineNum=1
while ($lineNum -lt $howLong)
{
echo `sed -n "$lineNum"p 046` `sed -n "$lineNum"p sc046_config` >> NEWFILE
let lineNum=$lineNum+1
}