avih75 / PickerFieldsControl

MIT License
0 stars 12 forks source link

CSV import does not support/recognize values in double-quotes with inner commas #28

Open lwalker-kforce opened 2 years ago

lwalker-kforce commented 2 years ago

Hi, can you kindly provide instruction on how I might be able to upload a CSV whose values contain commas occasionally? CSV format supports surrounding a column value (cell) with double-quotes if it includes commas when the comma is the delimiter. On import, the extension indicates there are duplicate values and when the picker renders, the values in the picker with the commas are broken. The double quotes also are visible. Furthermore, I have attempted to use both hex and ascii without success.

Example CSV

Field,L1,L2,L3
1,NoCommaL1.1,"WithComma, L2.1", NoCommaL3.1
2,NoCommaL1.2,NoCommaL2.2,"WithComma, L2.3"