how to use encapsulation while reading csv file.

Question

User1119325357 posted

How to read csv file using delimiters and encapsulation or encloser, escaper in asp.net vb.net

or how to use encapsulation while reading csv file.

for eg. following is a sample csv file data.

Salutation,FirstName,LastName,Address1,Address2
Ms, Shruti,Nene , 2520 Renuka Soc.,Suite 100,Pune
Dr.,Manali,Desarda, "2520, Renaissance Blvd","Suite, 100"

here in second row there is encapsulation used as " " and in between there is delimiter used as ','. so while reading that column field value we

need to skip the delimiters used in encapsulation and used whole text within  " " encapsulation as single column field value.