Answers.Body: <p>Welcome to S.E. and CiviCRM. Having Contacts without First and Last is quite common and is often done intentionally to get Contacts signed up for Mailing Lists. If a contact has no First or Last then it is correct that the email shows as their Display Name and their Sort Name.</p>
  
  <p>That said, if you really want to find and destroy/cull, then Search Builder (under Search) is your friend as it offers a Filter for 'IS NULL or IS Empty' hence you should be able to do something like the following</p>
  
  <p>Individual > First Name > Is NUll (or empty)
  Individual > Last Name > Is NUll (or empty)</p>
  
  <p>From the Actions tab you can then Export them, and then Delete them</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-03T18:31:00.187Z
Answers.LastActivityDate: 2018-04-03T18:31:00.187Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>If the First or Last Name field has been populated with the email address do a Search Builder search, and select the appropriate field and search for %@% using the Like operator.</p>
  
  <p>Individual > First Name > Like > %@%</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-04T15:20:15.383Z
Answers.LastActivityDate: 2018-04-04T16:08:05.327Z
Answers.LastEditDate: 2018-04-04T16:08:05.327Z
Answers.UserDisplayName: Davy Ivins
Body: <p>I inherited an installation where a predecessor imported an email list of 70K records and populated the Contact Name AND the Email address with the email address. </p>
  
  <p>How can I isolate, export, and remove them?</p>
  
  <p>Warning: noob alert. </p>
  
Tags: <contacts>
Title: contacts where name = email
ThreadText: # contacts where name = email
  
  (Asked by: username_0 on 2018-04-03)
  
  I inherited an installation where a predecessor imported an email list of 70K records and populated the Contact Name AND the Email address with the email address.
  
  How can I isolate, export, and remove them?
  
  Warning: noob alert.
  
  **Tags:** contacts
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-04-03. Score: 2
  
  Welcome to S.E. and CiviCRM. Having Contacts without First and Last is quite common and is often done intentionally to get Contacts signed up for Mailing Lists. If a contact has no First or Last then it is correct that the email shows as their Display Name and their Sort Name.
  
  That said, if you really want to find and destroy/cull, then Search Builder (under Search) is your friend as it offers a Filter for 'IS NULL or IS Empty' hence you should be able to do something like the following
  
  Individual > First Name > Is NUll (or empty)
  Individual > Last Name > Is NUll (or empty)
  
  From the Actions tab you can then Export them, and then Delete them
  
  
  ---
  
  ### Answer by username_2 on 2018-04-04. Score: 2
  
  If the First or Last Name field has been populated with the email address do a Search Builder search, and select the appropriate field and search for %@% using the Like operator.
  
  Individual > First Name > Like > %@%
  
  
  ---
  
  