Scripting question related to joining two files with a string added....

[Vijaya Kumar_3]

Hello,

I have two files named "abc" and "xyz". Their contents are here:

File "abc":

object1
object2
object3

File "xyz":

table1
table2
table3

My requirement is to create an command output like this.

delete from 'object1' on 'table1';
delete from 'object2' on 'table2';
delete from 'object3' on 'table3';

Right now, I played with "vi" and able to create the new file.... However, is it a better sed or awk one liner for this? or even perl?

I will assign the points.

Regards
Vijay Chinnasamy

[Bill Hassell · Accepted solution]

The easiest way is:

paste abc xyz

Then format the results into awk or other filters such as this:

$ paste abc xyz | while read OBJ TBL
> do
> echo "delete from '$OBJ' on '$TBL'"
> done
delete from 'object1' on 'table1'
delete from 'object2' on 'table2'
delete from 'object3' on 'table3'

[Vijaya Kumar_3]

Works like a champ. Thank you.