Filter incomplete email addresses using DataPrep or DataPrep + Zoho Worksheet

Filter incomplete email addresses using DataPrep or DataPrep + Zoho Worksheet

Hello,
I have a dataset containgin hundreds of email addresses. Each "email address could be:
  1. correct: i.e. info@companyname.ext
  2. incomplete: i.e. info@companyname
  3. empty
I can see Data Prep is able to recognize wrong data type:



Is there a way to manually filter the cells containing data of the wrong data type in order to be able to manually fix them?

Seems like DataPrep is not the right tool to do that: is there maybe a way to do that using Workdrive?

Thank you