Hello,
I want to find that how many comma separated values are there in 1 line of excel file. for example I have following two lines in excel file.

60, Item1, desc, 2000
10, Item2, desc3, 2000, INR, KG


There are 4 comma separated values in line 1
and 6 values in line 2.

I have used string.scan function.

but in this function I have to provide %s six times to get 6 values of line 2 from excel.

Is there any function to find out how many comma separated values are there in 1 line of Excel File(Comma separated)????

Hi,

A very good thread for this:-

Thread! (http://www.baanboard.com/baanboard/showthread.php?t=62728)

thank You..