I'm exporting data from SQL Server Management Studio to csv files and then importing them to ServiceNow by way of "load data", create a new import set row and data source. Everything is working great except for certain files that contain additional commas. I'm getting an error when creating a new data source indicating that it expected x number columns but found y number of columns.   I need to figure out how to resolve this. Here are more details.

1. I know it's being caused by the additional commas that are found inside some of the fields.   These fields that contain these, however, are enclosed inside double quotes which is valid csv.   I'm baffled why SN does not allow this.

2. I can temporarily open in Excel, search for commas and replace with spaces. The error goes away so I know the root cause is the extra commas. I cannot use this Excel find/replace as a permanent solution as I have many tables in which to do this for.

Here is a simple example showing what my valid csv file looks like.

header1, header2, header3, header4

data1, "data2 plus, comma in double quotes", data3, data4   <-- ServiceNow doesn't like this.

data5, data6, data7, "data8 plus, comma in double quotes" <-- ServiceNow doesn't like this.

p.s., the above is a valid format according to the Standard       RFC 4180