How to delete multiple empty contacts

(0) Share

Report

Posted on by Clare2013

155

I imported the contact csv file, then generated a lot of empty contacts in the system. I hope to use bulk delete to delete all the empty contacts. Anyone can tell me how to use express Empty or Blank field? E.g. I select Full Name equal "Blank" or "Empty". What expression I should use to represent "Blank" or "Empty".

thanks,

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

jlattimer 24,562 on at

Like (0)

Report

Try:

FieldName Does Not Contain Data

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

When you imported the CSV file, you can some records to find Import Sequence Number for those records. When you import a csv file it updates the Import Sequence Number field in that entity and it is unique for that csv file. Idntify that and use that field with Advanced find Field Does not contain Data, to bulk delete the records.

Was this reply helpful? Yes No
Clare2013 155 on at

Like (0)

Report

Hi Jason,

Did you mean, e.g. if select Full Name equals Does Not Contain Data, I can delete all the empty records?

I tried this way, it didn't work.

Was this reply helpful? Yes No
jlattimer 24,562 on at

Like (0)

Report

Do you not get any results? If it possible First or Last Names on these records have values? You might just Last Name Does Not Contain Data and also add a condition to check the Created On date - where that is equal to the day you imported.

Was this reply helpful? Yes No
Clare2013 155 on at

Like (0)

Report

Hi Jason,

Thanks! Succeed today.

Clare

Was this reply helpful? Yes No
Clare2013 155 on at

Like (0)

Report

Thank you, AMIT!

I opened the CSV file in Notepad and found lots of empty records at the end of the file, which I couldn't see in EXCEL. So the other way to help me is to remove all the empty records before import the file.

Thanks again, Clare

Was this reply helpful? Yes No