Shell Programming and Scripting

Hi,
I'm new to the scripting world...
I want to know that how can I assign the the field value(that has multiple lines) of a .csv file to a variable???

Model of my .csv file :

1 Poppy 5
2 red 6
3 black 5
4 white 8
and so on,the list continues..

My requirement is to assign the line values of the field2 to a variable and use one value of that variable at a time...

hope to hear from you guys soon

This sounds like homework

yea kind of....please guide me through this task...

Code:

while read a b c;do declare $b=$c;done < file
echo $Poppy
5

....
etc

Code:

declare $(awk '{print $2"="$3}' file)
echo $Poppy
5

thanks for your concern dude...
but my requirement is that the variable should hold the value [poppy red black white .......]
and in comparison which i'll be doing by using either for or while, in first execution it should pass poppy, in second red and so on....



---------- Post updated at 11:25 PM ---------- Previous update was at 11:23 PM ----------




i would be using that variable to query database for comparisons and if that object does exist there, it should return the field2 and field 3