Clay Icon

Troubleshooting Clay Crashes with Specific Formula Usage

·
·

When trying to add this Formula, clay crashes/freezes each time. However, the very same formula has worked fine before. This is the formula: {{Name}}?.replace(/[®©™℠●▪️♦️"""''„]/g, ' ') .replace(/@/g, ' ') // Handle specific encoding issues .replace(/ü/g, 'ü') .replace(/ö/g, 'ö') .replace(/ä/g, 'ä') .replace(/Ä/g, 'Ä') .replace(/Ö/g, 'Ö') .replace(/Ü/g, 'Ü') .replace(/ß/g, 'ß') .replace(/é/g, 'e') .replace(/è/g, 'e') .replace(/ë/g, 'e') .replace(/ê/g, 'e') .replace(/á/g, 'a') .replace(/à /g, 'a') .replace(/â/g, 'a') .replace(/ñ/g, 'n') .replace(/ó/g, 'o') .replace(/ò/g, 'o') .replace(/ô/g, 'o') .replace(/ú/g, 'u') .replace(/ù/g, 'u') .replace(/û/g, 'u') .replace(/[ÈÉÊËĒĔĖĘĚȄȆẸẺẼẾỀỂỄỆ]/g, 'E') .replace(/[ÌÍÎÏĨĪĬĮǏȈȊḬḮỈỊỐỒỔỖỘỚỜỞỠỢ]/g, 'I') .replace(/[ÒÓÔÕŌŎŐƠǑǪǬȌȎỌỎỐỒỔỖỘỚỜỞỠỢ]/g, 'O') .replace(/[ÙÚÛŨŪŬŮŰŲƯǓǕǗǙǛȔȖỤỦỨỪỬỮỰ]/g, 'U') .replace(/[èéêëēĕėęěȅȇẹẻẽếềểễệ]/g, 'e') .replace(/[àáâãāăąǎǟǡǻȁȃạảấầẩẫậắằẳẵặ]/g, 'a') .replace(/[ìíîïĩīĭįǐȉȋḭḯỉịốồổỗộớờởỡợ]/g, 'i') .replace(/[òóôõōŏőơǒǫǭȍȏọỏốồổỗộớờởỡợ]/g, 'o') .replace(/[ùúûũūŭůűųưǔǖǘǚǜȕȗụủứừửữự]/g, 'u') .replace(/[ç]/g, 'c') .replace(/[ÿ]/g, 'y') .replace(/[ñ]/g, 'n') .replace(/\/\//g, '/') .replace(/\s+/g, ' ') .trim()

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    The formula may be causing issues due to hidden characters or syntax problems. Here are a few troubleshooting steps: 1. Copy and paste your formula into a plain text editor first to remove any potential hidden characters that could be causing the crash. 2. Check your syntax carefully, ensuring: • All quotes are properly formatted • Commas and other punctuation are correctly placed • No extra spaces are present where they shouldn't beIf the issue persists after trying these steps, please request a human agent to help investigate the specific formula, as they can better diagnose complex formula-related problems. Source: HTTP API integration overview | Documentation | Clay University

  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    This is not the issue as

    • The formula itself works

    • The formula that worked before had the same (even more) special ccharacters

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    This is the updated formula that only contains special characters as they appear in the data I want to clean (even less complex formula) and it still crashes/freezes: {{Name}}?.replace(/[®©●▪️"""''„]/g, ' ') .replace(/@/g, ' ') // Handle specific encoding issues .replace(/ü/g, 'ü') .replace(/ö/g, 'ö') .replace(/ä/g, 'ä') .replace(/Ä/g, 'Ä') .replace(/Ö/g, 'Ö') .replace(/Ü/g, 'Ü') .replace(/ß/g, 'ß') .replace(/é/g, 'e') .replace(/è/g, 'e') .replace(/ë/g, 'e') .replace(/ê/g, 'e') .replace(/á/g, 'a') .replace(/à /g, 'a') .replace(/â/g, 'a') .replace(/ñ/g, 'n') .replace(/ó/g, 'o') .replace(/ò/g, 'o') .replace(/ô/g, 'o') .replace(/ú/g, 'u') .replace(/ù/g, 'u') .replace(/û/g, 'u') .replace(/[ÈÉÊËĒĔĖĘĚȄȆẸẺẼẾỀỂỄỆ]/g, 'E') .replace(/[ÌÍÎÏĨĪĬĮǏȈȊḬḮỈỊỐỒỔỖỘỚỜỞỠỢ]/g, 'I') .replace(/[ÒÓÔÕŌŎŐƠǑǪǬȌȎỌỎỐỒỔỖỘỚỜỞỠỢ]/g, 'O') .replace(/[ÙÚÛŨŪŬŮŰŲƯǓǕǗǙǛȔȖỤỦỨỪỬỮỰ]/g, 'U') .replace(/[èéêëēĕėęěȅȇẹẻẽếềểễệ]/g, 'e') .replace(/[àáâãāăąǎǟǡǻȁȃạảấầẩẫậắằẳẵặ]/g, 'a') .replace(/[ìíîïĩīĭįǐȉȋḭḯỉịốồổỗộớờởỡợ]/g, 'i') .replace(/[òóôõōŏőơǒǫǭȍȏọỏốồổỗộớờởỡợ]/g, 'o') .replace(/[ùúûũūŭůűųưǔǖǘǚǜȕȗụủứừửữự]/g, 'u') .replace(/[ç]/g, 'c') .replace(/[ÿ]/g, 'y') .replace(/[ñ]/g, 'n') .replace(/\/\//g, '/') .replace(/\s+/g, ' ') .trim()

  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    This is the updated formula and I really need it to work!!! Why is this such an issue 😞 {{Name}}? .replace(/[®©™℠●▪️♦️""'»„]/g, '') .replace(/@/g, '') // Fix German encoding issues .replace(/ä/g, 'ä') .replace(/Ö/g, 'Ö') .replace(/Ä/g, 'Ä') .replace(/ß/g, 'ß') .replace(/é/g, 'é') // Handle non-German accented characters .replace(/[éè]/g, 'e') .replace(/ç/g, 'c') .replace(/ú/g, 'u') .replace(/ô/g, 'o') .replace(/æ/g, 'ae') .replace(/ã/g, 'a') // Clean up formatting .replace(/\s+/g, ' ') .replace(/^[\s-]+|[\s-]+$/g, '') .replace(/\(\s*\)/g, '') .replace(/\[\s*\]/g, '') .replace(/\{\s*\}/g, '') .replace(/[-]{2,}/g, '-') .replace(/[.]{2,}/g, '.') .trim()

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Maximilian - Do you mind sending the link to the table so we can take a look? Also, what exactly are you trying to achieve here? Do you have the table that was previously working? If you can let me know exactly what prompt you want to do, I can add it in the AI formula generator and we can achieve this with a working method instead. This formula is most likely crashing for the special characters, taking a heavy load on the system. https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1736520300&signature=e84bbfe9059cff5d64806ed8f23edb6bbbda7297c838c8f14ae9aa04c1ffd0b8&req=dSEgF85%2FmohWX%2FMW1HO4zYTywS35BJcV2BKscGjkVdydQOJsZ6yYnYhO2Pjf%0AEysJI%2Bm7mnxmY6vvmnM%3D%0A

  • Avatar of Daniela D.
    Daniela D.
    ·
    ·

    Hey Maximilian! Thanks for reaching out. Happy to help. Could you share the url for the table that has the same formula working and the table you're trying to set it up in? It looks like your formula is trying to normalize company names and remove the special characters listed. If you can share your table url, I'm happy to troubleshoot and share suggestions. https://downloads.intercomcdn.com/i/o/w28k1kwz/1329234123/d1babdf00faf32c802f6f519ea2f/image.png?expires=1736520300&signature=efa75f20cb4eb0e84f5dd72e15fc848e54eb3781940bccded144aa4afa0758e7&req=dSMlH8t9mYBdWvMW1HO4zZ9KUdf%2B04HQtL5v13DYb5QYAqsZTg5dDkvUzLkF%0AAE5WxhkSuFcDtEegM70%3D%0A

  • Avatar of Channeled
    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.