After I run this.. what is the best way to export the good emails? als...

After I run this.. what is the best way to export the good emails? also How do I clear all of the other data without messing up the formulas? https://app.clay.com/workspaces/45787/tables/t_bSqKyuCJhW06/views/gv_cxDXBXa2fH31

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
Hey Mark, thanks for reaching out and apologies for the delay!
Clay Team
APP
·
The best way to surface valid emails is to filter the column to show non-empty rows. You can then choose to download the CSV or if you're using any of the email tools like Smartlead and such you can export them directly to that account (depending on the plan).Filters shouldn't mess with any of your formulas either.
aa69af44-b7ae-4f45-986b-baca94f16e86.png(20 kB)
Clay Team
APP
·
Let me know if you run into any issues!
Mark M.
·
when I hit filter on this column.. it says Where - equal to- then blank… what type of filter am I doing? then after I get info can I just copy and delete all data in columns to keep clean?
Clay Team
APP
·
You'll be changing "equal to" for "is not empty" and that would do it.
Clay Team
APP
·
And yes, you can download that CSV to keep the data you found and delete the records if you'd like. Otherwise, you can still keep it there for future reference if you need them
Mark M.
·
can you look at this, trying to add new rows 47-56 says missing input https://app.clay.com/workspaces/45787/tables/t_bSqKyuCJhW06/views/gv_cxDXBXa2fH31
Clay Team
APP
·
Hey Mark! Sure, I'll take a look at what may be missing there
Mark M.
·
I think I figured it out