Skip to content

SQLServerBulkCSVFileRecord should CSV library to split data #1173

@gauravjhs

Description

@gauravjhs

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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    EnhancementAn enhancement to the driver. Lower priority than bugs.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions