What is the correct syntax to csv import multile values to a multi select field for the same record?

AI generated answer (using internal Slack threads):

To import multiple values to a multi-select field for the same record in NetSuite via CSV, you need to separate the values with a pipe character

|

. This is the default delimiter for multi-select fields in CSV imports. Here is an example of how you would format your CSV file:

RecordID, MultiSelectField
1, Value1|Value2|Value3
2, Value1|Value2
3, Value1|Value2|Value3|Value4

In this example,

RecordID

is the identifier for your record, and

MultiSelectField

is the multi-select field where you want to import the values.

Value1

,

Value2

, etc. are the values you want to import into the multi-select field. If you want to use a different delimiter, such as a comma, you can change the delimiter under the advanced options during the import process. However, be careful with using a comma as it is the default delimiter for CSV files and might cause issues with the import. Please note that if you want to append values to a multi-select field during import, you might need to export all the existing records, add the new values in the CSV file, and then re-import the records. This is because NetSuite might overwrite the existing values in the multi-select field during the import. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******