Answers.Body: <p>I would probably create a profile with the website, and then use the 'update multiple contacts' to clear the website a hundred at a time (which is the maximum of contacts you can update with one profile action).</p>
  
  <p>First you need to create a profile, and read up on profiles in the User Guide if you are not familiar with them.
  Next you search for your contacts, and select a maximum of 100 at a time, and select the 'update multiple contacts' from the action list. You then select the profile and use the 'copy' functionality to set the website to empty.
  I have not tried this, but this is what I would try to do if updating SQL is not an option.</p>
  
  <p>If that does not work you will probably either clean them in the database OR delete the contacts and re-import (if that is an option).</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-08T18:50:26.067Z
Answers.LastActivityDate: 2016-12-08T18:50:26.067Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I have updated some contacts and during import there was a mixup in some fields, i.e. an individual's "Website" field was filled with the value of an Organisation's website.</p>
  
  <p>I want to set the value of "Website" field for this individual to empty. I tried updating the contact with both <em>Update</em> and <em>Fill</em> options, leaving the "Website" field empty, but this didn't work.</p>
  
  <p>What is the best way to do this?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-30T11:18:55.877Z
Comments.Text: what version of CiviCRM are you using? Do you have SQL skills and access to the database?
Comments.UserDisplayName: ErikH - CiviCooP
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-08T17:20:26.637Z
Comments.Text: Version is 4.7.13. Unfortunately no skills in database handling!
Comments.UserDisplayName: Vassilis Chryssos
Tags: <import><upgrade>
Title: Update contact's field to empty value
ThreadText: # Update contact's field to empty value
  
  (Asked by: username_0 on 2016-11-30)
  
  I have updated some contacts and during import there was a mixup in some fields, i.e. an individual's "Website" field was filled with the value of an Organisation's website.
  
  I want to set the value of "Website" field for this individual to empty. I tried updating the contact with both *Update* and *Fill* options, leaving the "Website" field empty, but this didn't work.
  
  What is the best way to do this?
  
  **Tags:** import, upgrade
  
  > **Comments:**
  > **username_1**: what version of CiviCRM are you using? Do you have SQL skills and access to the database?  
  > **username_0**: Version is 4.7.13. Unfortunately no skills in database handling!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-12-08. Score: 1
  
  I would probably create a profile with the website, and then use the 'update multiple contacts' to clear the website a hundred at a time (which is the maximum of contacts you can update with one profile action).
  
  First you need to create a profile, and read up on profiles in the User Guide if you are not familiar with them.
  Next you search for your contacts, and select a maximum of 100 at a time, and select the 'update multiple contacts' from the action list. You then select the profile and use the 'copy' functionality to set the website to empty.
  I have not tried this, but this is what I would try to do if updating SQL is not an option.
  
  If that does not work you will probably either clean them in the database OR delete the contacts and re-import (if that is an option).
  
  
  ---
  
  