Reading variables from CSV file

Shell Programming and Scripting
1

Hi I am using KSH and trying to read variables from a csv file. I've set the IFS=, and it workds. Problem is where one of the values is text containing a comma. For example the following lines exist in my file. How can I read everything between the quotes into a single variable?

APW13812,,1 ,443,"SHOES DONT MATCH- VARYING UPPER MATERIAL, COLOR AND/OR TEXTURES",526502,02 09,07 09,$29.60
APW13881,,1 ,411,"SEPARATION AT TOE OR HEEL, BUMPER ADHESION",526502,04 09,07 09,$29.10

I am using the following loop to read the variables:

 
cat file.csv | while IFS=, read var1 var2 var3 etc
do
  do something
done
2 
 awk -F[\"] '{print $2}' file.csv  |while  read var1
do
  echo $var1
done
3

Perl magic regular expression is always best way to archieve such kind of thing.

while(<DATA>){
	my @tmp=split(/,(?=
	(?:[^"]*$)
	|
	(?:(?:[^"]*"[^"]*")*[^"]*$)
	)/x,$_);
	print join " <--> ", @tmp;
}
__DATA__
APW13812,,1 ,443,"SHOES DONT MATCH- VARYING UPPER MATERIAL, COLOR AND/OR TEXTURES",526502,02 09,07 09,$29.60
APW13881,,1 ,411,"SEPARATION AT TOE OR HEEL, BUMPER ADHESION",526502,04 09,07 09,$29.10