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


      Zoho Developer Community




          Bootcamp
          Community
          Pricing
          Webinars
          What's New
          Integrations
          Contact Support
          Contact Sales



              Zoho Survey Resources
                Features
                Survey Templates
                Integrations
                Community
                iOS Mobile Surveys
                Pricing
                Android Mobile Surveys
                Insurvey Blogs
                Insight Blogs
                Tips & Tricks





                              Latest Feature Updates

                                Zoho Desk Resources

                                • Desk Community Learning Series


                                • Digest


                                • Functions


                                • Meetups


                                • Kbase


                                • Resources


                                • Glossary


                                • Desk Marketplace


                                • MVP Corner


                                • Word of the Day




                                    Zoho Marketing Automation
                                      Zoho SalesIQ Resources

                                            • Sticky Posts

                                            • 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


                                            Manage your brands on social media
                                            Access Zoho Social

                                              Zoho Pagesense Resources


                                                  Zoho TeamInbox Resources

                                                    Zoho DataPrep Resources



                                                      Zoho CRM Plus Resources

                                                        Zoho Books Resources


                                                          Zoho Subscriptions Resources

                                                            Zoho Projects Resources


                                                              Zoho Sprints Resources


                                                                Qntrl Resources


                                                                  Zoho Creator Resources


                                                                    Zoho WorkDrive Resources



                                                                      Zoho Campaigns Resources

                                                                        Zoho CRM Resources

                                                                        • CRM Community Learning Series

                                                                          CRM Community Learning Series


                                                                        • Tips

                                                                          Tips

                                                                        • Functions

                                                                          Functions

                                                                        • Meetups

                                                                          Meetups

                                                                        • Kbase

                                                                          Kbase

                                                                        • Resources

                                                                          Resources

                                                                        • Digest

                                                                          Digest

                                                                        • CRM Marketplace

                                                                          CRM Marketplace

                                                                        • MVP Corner

                                                                          MVP Corner







                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now