Read Comma separated file containing commas, single/ double quotes, line feed characters.
Read Comma separated file containing commas, single/ double quotes, line feed characters. While working in iSupplier implementation, we need to upload comma separated file containing ASN data provided by the client into database. While using comma separated file, user had restrictions not to put comma or any special characters in the file. But what if user needs to upload his address information into database. Address may contain commas and/or special characters. Below is the code that reads CSV file containing commas, special characters/quotes and inserts filtered data into database. /************************************************************************************************************* * * Reading Data from comma separated file, this code will filter the data from comma separated * file and then insert that data into table. * * * *******...