How to Remove [blank] Cells in Clay.com Efficiently | Clay

How to Remove [blank] Cells in Clay.com Efficiently

👋 Hello, team! I have a table full of data where some cells aren't empty but instead contain the word [blank] or blank. I'd like to filter out these cells and remove that text in one go. For example, in Excel, I can just use Ctrl+F, search for [blank], leave the Replace with field empty, and click Replace All—this turns those cells into truly empty cells. Is there a similar way to do this in clay.com? Thanks!

5 comments

Channeled
APP
·
·
You can use our "Normalize" tools to clean up text like "[blank]" or "blank" in your data: 1. Go to "Add enrichment" panel 2. Select "Normalize" in the left sub-navigation 3. Choose "Normalize and Deduplicate a List" 4. Select your column containing "[blank]" text 5. Enable "Remove empty values" option 6. Run the action across your rows This will clean up your data by removing these placeholder texts.
Sources: Data Cleaning + Normalization [Automated Inbound] - Clay University Data Cleaning + Normalization [Clay 101] - Clay University Data Cleaning + Normalization [Clay 101] - Clay University Normalize and Deduplicate a List with Clay
Sasikumar
·
·
Possible to get a video example? The support is slightly confusing
Bo (.
·
·
Hey, The best way to do this in Clay is by using a Formula column. 1. Go to the far right of your table and click Add Column → Formula 2. In the formula, reference the column you want to clean using a forward slash (e.g. /yourColumn) 3. Use a formula like: LBKSif /yourColumn is "blank" leave empty otherwise return the emailLBKS1. This will replace any "blank" values with an empty cell Let me know if you want help setting this up!
Bo (.
·
·
See here for formulas https://www.clay.com/university/lesson/how-to-use-ai-formulas
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.