UNIX for Dummies Questions & Answers

Hi,
I'm relatively new to shell scripting, Ive worked on a few basic scripts and used most of the unix commands in the simplest of situations. But I am now faced with a task that's seems to be beyond me.

I have a file with some data in the form of rows and columns :

123 4536 abcd4 677 bbb ggg nnn 32425
343 5656 abcd6 566 eee fff ooo 56454
343 5645 abcd7 556 ddd lll jjj 43536....
.
.
.
and so on

I need a shell script to pick this data and put it into an insert command which lies in another text file.The insert command would be in the form insert into table_xyz values ($a,'$b','$c',etc) where the variables would be the values from the above mentioned data file. the output of the script should be as many insert statements as there are lines in the data file.As in,
insert into table_xyz values(123, 4536, 'abcd4', 677, 'bbb', 'ggg', 'nnn' ,32425)
insert into table_xyz values(343, 5656, 'abcd6', 566, 'eee', 'fff', 'ooo' 56454) etc

Some sort of script to store the data in an array or something and iterate through it?Any help,advice would be greatly appreciated...

Thanx in advance

No duplicate or cross-posting, please read the rules.

Continue here:

https://www.unix.com/shell-programmin...#post302273504

Thread closed.