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




      • Sticky Posts

      • Announcement: Migrate your workspaces to Zoho DataPrep 2.0

        Zoho DataPrep 2.0 was recently launched with exciting new updates to the platform. You can read more about the new updates in the previous announcement. To take full advantage of the new data pipeline features, migrate your existing workspaces from the

      • Announcing Zoho DataPrep 2.0: An AI-Powered Data Management Platform

        Originally launched in 2021, Zoho DataPrep started as an efficient self-service data preparation solution. We are excited to launch our new version 2.0, with significant enhancements to our platform to help you manage your end-to-end data needs with the

      • Announcing DataPrep 2.0 Beta!

        Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage. With that said, how confident are you in making business decisions

      • 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