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.