rowly 0 Junior Poster in Training

Hello,
can you guyz help write a while loop to read this line, for example
2,Joind,2082421,235.6,8
2= number
Joind = item
2082421 = item number
235.6 = item price
8 = day
all what i'm tryin to do is while reading each line if we encounter a ',' store all the characters in the specific array for example number, item , item number , item price, day.
i know how to store them but i dont know how to write the while loop
to read each character untill we encounter a ',' because its an excel file not a normal file.
thx alote
2,Joind,2082421,235.6,8
'
'
'
'
'
'
'
'
'