forcedotcom
Trying to upload a CSV with fields that contain commas.
Some of the field values have commas in them which is causing issues when uploading. I have tried surrounding that field in double quotes and it accepts the field but won't match it to the correct value as it doesn't remove the double quotes. Any suggestions?
will test this out and get back to you - thanks for bringing to our attention
Hi @sricharananand I am having the same issue as well. Do you know when this can be fixed? Thanks.
Hi @mikecon94 do you have any workaround for this instead of manually updating the values? Thanks.
Hi @mychan-wdci, I'm afraid not. Fortunately for us we didn't have many records with commas in so we just removed them from the upload and added them manually. One workaround we thought about was replacing the commas with a placeholder character such as a ~ for the upload and then changing it back to a comma afterwards so maybe you could give that a try.
I can confirm this one as well. We have comma separated value in a column. Therefore, we surrounded the values with double quotes (e.g. "12345,67890"). When importing, it must have ignored the quotes, detected the comma, and started a new column. All our data was shifted to the right by a column every time it detected a comma in the column values
