👋 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!
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.
Possible to get a video example? The support is slightly confusing
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 emailLBKS
1. This will replace any "blank" values with an empty cell
Let me know if you want help setting this up!
See here for formulas https://www.clay.com/university/lesson/how-to-use-ai-formulas
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.