Answers.Body: <p>If you completly want to delete the addresses, you could also delete them from the database with a query like <code>DELETE FROM civicrm_address WHERE location_type_id = xx AND contact_id IN (SELECT entity_id FROM civicrm_entity_tag WHERE entity_table = 'civicrm_contact' AND tag_id = yy)</code></p>
  
  <p>Where <code>xx</code> stands for the id of the location type you want to delete 
  and <code>yy</code> is the id of the tag. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-17T12:34:46.257Z
Answers.LastActivityDate: 2018-08-17T12:34:46.257Z
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Answers.Body: <p>See the docs section on profiles and then using batch update from the search results actions dropdown, i.e. search for your tag and then choose batch update via profile, and choose a profile that has your address fields.
  <a href="https://docs.civicrm.org/user/en/latest/organising-your-data/profiles/#updating-multiple-records-at-the-same-time" rel="nofollow noreferrer">https://docs.civicrm.org/user/en/latest/organising-your-data/profiles/#updating-multiple-records-at-the-same-time</a></p>
  
  <p>It may have the same thing as import where it interprets blank as "no change". If so, you could try fooling it with a space character as the address.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-16T19:56:32.117Z
Answers.LastActivityDate: 2018-08-16T19:56:32.117Z
Answers.UserDisplayName: Demerit
Body: <p>I have several hundred individual records that have bad mailing address and have tagged them in CiviCRM. How can I delete these from the system in bulk? I have tried Civi's upload process by leaving the address blank and using the overwrite duplicate setting, hoping this would blank out their address, but that has no effect.</p>
  
  <p>Thank you.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-16T19:55:59.667Z
Comments.Text: Are you using Drupal with CiviCRM?
Comments.UserDisplayName: jackrabbithanna
Tags: <addresses><tags><upload>
Title: Mass deletion of bad addresses
ThreadText: # Mass deletion of bad addresses
  
  (Asked by: username_0 on 2018-08-16)
  
  I have several hundred individual records that have bad mailing address and have tagged them in CiviCRM. How can I delete these from the system in bulk? I have tried Civi's upload process by leaving the address blank and using the overwrite duplicate setting, hoping this would blank out their address, but that has no effect.
  
  Thank you.
  
  **Tags:** addresses, tags, upload
  
  > **Comments:**
  > **username_1**: Are you using Drupal with CiviCRM?  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2018-08-17. Score: 5
  
  If you completly want to delete the addresses, you could also delete them from the database with a query like `DELETE FROM civicrm_address WHERE location_type_id = xx AND contact_id IN (SELECT entity_id FROM civicrm_entity_tag WHERE entity_table = 'civicrm_contact' AND tag_id = yy)`
  
  Where `xx` stands for the id of the location type you want to delete
  and `yy` is the id of the tag.
  
  
  ---
  
  ### Answer by username_3 on 2018-08-16. Score: 3
  
  See the docs section on profiles and then using batch update from the search results actions dropdown, i.e. search for your tag and then choose batch update via profile, and choose a profile that has your address fields.
  <https://docs.civicrm.org/user/en/latest/organising-your-data/profiles/#updating-multiple-records-at-the-same-time>
  
  It may have the same thing as import where it interprets blank as "no change". If so, you could try fooling it with a space character as the address.
  
  
  ---
  
  