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:

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

Sticky Posts
Zoho CRM connector's export functionality enables end-to-end CRM data pipeline
We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,
Zoho DataPrep is now launched!
We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service. Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data

Topic Participants