Answers.Body: <p>I tried this and was able to get it to null the field.  I needed to put null in the field in the cvs.  I had to make sure the null did not have any quotes around it.  Just the word null between the commas.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-16T02:12:45.547Z
Answers.LastActivityDate: 2017-02-16T02:12:45.547Z
Answers.UserDisplayName: Paul-Tahoe
Answers.Body: <p>Paul-Tahoe's answer works for me but isn't documented! I needed it, too. 
  The word "null" worked both with and without quotes around it in the CSV file.
  It clears the field (only without the quotes) even if you type it directly into a text field in the UI. (This incidentally seems to imply you can't store the single word 'null' without quotes in a text field, which I'm sure is undocumented.)</p>
  
  <p>Note that 'null' cannot be used in imports for the State-Province or Preferred-Communication-Method fields, for example. I've no workaround for this at present.</p>
  
  <p>Please see my suggestion for improvements to the Import function at this question > <a href="https://civicrm.stackexchange.com/questions/17388/is-there-an-import-option-to-allow-overwriting-fields-with-null-empty?s=3|0.1440">Is there an Import option to allow overwriting fields with null (empty)?</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-23T18:57:42.550Z
Answers.LastActivityDate: 2017-02-24T15:29:04.633Z
Answers.LastEditDate: 2017-04-13T12:53:13.167Z
Answers.UserDisplayName: David Hepper
Body: <p>When I import cleaned postal data and the supplemental address information has moved to the first line of the address, the supplemental address data does not clear, even if I put a space in the field. This results in addresses with errors that don't CASS the next time. How can I do an import and set that field to NULL?</p>
  
Tags: <import><upgrade>
Title: Clear data from supplemental address on update
ThreadText: # Clear data from supplemental address on update
  
  (Asked by: username_0 on 2017-02-10)
  
  When I import cleaned postal data and the supplemental address information has moved to the first line of the address, the supplemental address data does not clear, even if I put a space in the field. This results in addresses with errors that don't CASS the next time. How can I do an import and set that field to NULL?
  
  **Tags:** import, upgrade
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-02-16. Score: 3
  
  I tried this and was able to get it to null the field. I needed to put null in the field in the cvs. I had to make sure the null did not have any quotes around it. Just the word null between the commas.
  
  
  ---
  
  ### Answer by username_2 on 2017-02-23. Score: 2
  
  username_1's answer works for me but isn't documented! I needed it, too.
  The word "null" worked both with and without quotes around it in the CSV file.
  It clears the field (only without the quotes) even if you type it directly into a text field in the UI. (This incidentally seems to imply you can't store the single word 'null' without quotes in a text field, which I'm sure is undocumented.)
  
  Note that 'null' cannot be used in imports for the State-Province or Preferred-Communication-Method fields, for example. I've no workaround for this at present.
  
  Please see my suggestion for improvements to the Import function at this question > [Is there an Import option to allow overwriting fields with null (empty)?](https://civicrm.stackexchange.com/questions/17388/is-there-an-import-option-to-allow-overwriting-fields-with-null-empty?s=3|0.1440)
  
  
  ---
  
  