Hi guys ๐
Request: String/Domain Normalization Features
Generally, Clay would fit perfectly in this role due to its spreadsheet style set-up.
However, there are barely any text or domain normalization features such as:
Handling special characters (e.g. ยฎยฉโขโ โโช๏ธ""''โโ"@ยฑโโ โ)
Handling encoding issues (e.g. รยผ/g -> รผ)
Handling accented/diacritical characters (e.g. แบฟแปแปแป
แป -> e)
Handling whitespace and formatting (e.g. leading/trailing whitespace, multiple spaces)
Phone number formatting (e.g. as used in Hubspot)
It would be amazing if the rules would be customizable and saved as templates/profiles.
Right now, you are kind of able to do this with Formulas but they tend to crash for more than a few rules.