Read CSV value with multiple commas

[harishkm]

Hello,

I want to read a CSV file in c# which is of the following format:

"California", "Sunnyvale", "1,2,3", "some address with unknown number of commas"

If I use Split(',') function, each value separated by commas is being considered a separate column and my database table has only fixed number of rows to store the values read from CSV file.

How do I eliminate the commas within a CSV column/value?

Thanks

Continue reading...