changing import delimiter

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you have two options to change the delimiter in a CSV file: 1. If you are generating the CSV file yourself using SuiteScript, you can use the

File.appendLine

method to build the CSV line by line. In this case, you can choose your own delimiter, such as a pipe (|) instead of a comma (,). You would need to manually construct each line of the CSV, concatenating your data fields with the pipe character. 2. If you are dealing with CSV files in NetSuite more generally, there is a setting in

Home -> Preferences

that changes the CSV Column Delimiter. This setting affects the standard CSV Import functionality in NetSuite. Please note that if you are using a different system to open the CSV file (like Excel), you might need to adjust the settings in that system to correctly interpret the delimiter. For example, in Excel, you can change the delimiter settings to correctly open CSV files with different delimiters. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******