When doing a csv import, I want to update a custom...
# ask-stanley-ai
l
When doing a csv import, I want to update a customer address, in this update, I want to clear one of the fields, in order to this, should I pass an empty string for this field? (""), just leave the field blank (without quotes)? or should I pass a space character (" ")?
c
AI generated answer (using internal Slack threads):
Based on the conversations, when doing a CSV import to update a customer address and you want to clear one of the fields, you should leave the field blank (without quotes) in the CSV file. However, you need to ensure that the 'Overwrite Missing Fields' option is checked in the 'Advanced Options' during the import process. This will allow NetSuite to overwrite the existing data with the blank value from the CSV, effectively clearing the field. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840948343
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840298116
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840112
Please provide your feedback on this answer.