Is your feature request related to a problem? If so, please give a short summary of the problem and how the feature would resolve it
Currently SQLServerBulkCSVFileRecord uses String split method to get data to insert in columns. CSV are generally not as simple as just splitting them using the separator. It gets frustrating when there is some text which contains separator as part of the value.
Describe the preferred solution
SQLServerBulkCSVFileRecord should use a proper CSV library to extract data from the csv file.
Describe alternatives you've considered
Generate CSV's using a unique separator which is not present in data(which at times becomes very difficult when data comes from user)
Is your feature request related to a problem? If so, please give a short summary of the problem and how the feature would resolve it
Currently SQLServerBulkCSVFileRecord uses String split method to get data to insert in columns. CSV are generally not as simple as just splitting them using the separator. It gets frustrating when there is some text which contains separator as part of the value.
Describe the preferred solution
SQLServerBulkCSVFileRecord should use a proper CSV library to extract data from the csv file.
Describe alternatives you've considered
Generate CSV's using a unique separator which is not present in data(which at times becomes very difficult when data comes from user)