Hello, I constantly have issues using Clay's AI or others to get a clean column of domain names. When I use their templates I get this type of output:
You can generate a clean column of domain names in Clay using either the Formula Generator or the Use AI feature: 1. Using Formula Generator: • Click "Add column" and select "Formula" • Enter instructions like "Extract the domain from {{Email}}" (where Email is your source column) • Click "Generate formula" to create your AI formula 2. Using AI for data cleaning: • Click "Add column" and select "Use AI" • Choose "Content creation, manipulation" as the use case • Write a prompt specifying you need clean domain names • Define your output field with the appropriate data type For example, if you have email addresses and need just the domains, you can use the formula generator with "Extract the domain from {{Email}}" to get clean results.
Hey Joseph, thanks for reaching out and for flagging this. Which template were you using specifically that resulted in this output would love to make sure we make note of this. When creating net-new prompts and asking for a domain to be returned I cannot say I've seen output like this.