Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
CSV Import Field Contains Comma
I am trying to import some customer records into NetSuite via a CSV file.
Several records in the CSV file have a column that contain a comma.
On import I get an error communicating wrong number of columns because the comma in one column value is being interpreted as a new column in that row.
I have tried using different delimiters for the columns, text wrapping column values that contain a comma with quotes but I still get an error.
The only way I have been able to get past the first stage of the import process is to remove all comma's from any column values that contain a comma, meaning the only comma's present in the CSV are too delimit a column.