Shell Programming and Scripting

Hi ,
I am new to this scripting , I am facing an issue like how to read different values from external file by using different variables,
In script I supposed to declare
var 1
var 2
var 3
I know how to call this variables from external file (I am using awk command by giving same name in script and extrnal file ), but the problem is here,
suppose I gave in awk command var1 is string1, var2 is string2 and var3 is string3

in external file i am having these values
string1 value1,value2,value3
string2 value4,value5,value6
string3 value7,value8,value9
now my update query has run only at a time
value 1, value 4 and value 7 , next run value 2,5,8 and value3,value6 and value9

I hope i gave you proper explanation about my problem,
Can some one give idea how to read these different variables in to script recursively..

Thanks in advance

You want to read in values using awk, and then use them in shell script?

It may be easier to use only shell, or only awk, to do all processing.

It would help a lot to see what you have now, and/or sample of desired input and output.

If I understand what you want, you can read into variables inside shell like this:

Code:

while IFS="," read A B C D
do
        echo "A=$A B=$B C=$C D=$D"
done < datafile

The IFS controls what it splits on. By default it's whitespace.

Hi Corona,
Thank you very much, I implemented with your logic, it works fine,
this is the logic I wrote in scrpt

Code:

infile=`more ${mydir} | grep 'TEXTINFO' | awk '{print $2}`
while IFS="," read var1 var2 var3
do
  update query 
done < $infile