Clay Icon

Request for Advanced String and Domain Normalization Features

·
·

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)

  • Case management rules

  • 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.

  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    Add-on: Company Name Normalization for any possible legal entity name. Currently, EU entitites are not recognized

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Maximilian J.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Maximilian J.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    Why is this thread simply closed?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    Did this request reach any ears??

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Maximilian J.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Erol T.
    Erol T.
    ·
    ·

    FWIW a really cheap/easy way i do this type of thing is just have an HTTP callout column that hits a hosted script and the script does all the cleanup. 🙂 Maximilian J.

  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    Erol T. thanks for the tip!! Where do you host your script?

  • Avatar of Erol T.
    Erol T.
    ·
    ·

    since it's for my personal use i do it on a simple php script i keep on my server it would be very simple to do in AWS lambda and have chatgpt write you a javascript/python script for whatever you want and then you don't have to worry about hosting