Bulk Fix for Claygent Output Issues Despite Prompt Clarity

Claygent issue - some outputs having {Response: I notice this happens often, even when I specifically say in the prompt "only output the 2-3 word response to complete this sentence:" Doesn't seem like a prompt issue as this happens on various use cases and campaigns I've run, where one result every so often is messed up like this. Is there a way to fix this in bulk, without having to manually check for this in the list?

9 comments

Channeled
APP
·
·
Yes, you can address this using our data cleaning tools! Here are two approaches:1. Use the Text Whitespace normalization tool to ensure consistent spacing and remove unexpected formatting across your data. 2. Create a formula column to automatically clean up the text: • Select "formula" for a new column • Use Clay's AI formula feature to automatically format your text • Review the output and click "Output is correct" to apply the formatting consistently across all rowsFor basic cleanup, you can also use our "Remove Extra Whitespace from Text" formatter, which will automatically eliminate unnecessary spaces, tabs, and line breaks from your text. Sources: FAQ: How can I format my text with line breaks and paragraphs before sending it to my email sequencer? Data Cleaning + Normalization [CRM Enrichment] - Clay University Remove Extra Whitespace from Text with Clay Formatters
Channeled
APP
·
·
Hi AJ C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback AJ C.!
Jacob T.
·
·
AJ C. This is annoying, not sure why it's happening without taking a closer look in your table. An easy fix for now though is using a formula column to remove any "response" text or anything besides your desired output format.
Jacob T.
·
·
AJ C. if you have any more questions/need help, please don't be a stranger!
Channeled
APP
·
·
Could you provide more details about the specific output format you're aiming for in your Claygent results?
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.
AJ C.
·
·
Question
AJ C.
·
·
2 actually First - what formula would I use to remove any "response" text? there's a lot of extra text in there I'm not sure how I'd approach this formula to clean it up, any ideas? Second - I tried to make a "Contains" filter over this column to only show which rows had that weird {Response{ text, that way I could fix it manually pretty easily by just re running the rows. the "Contains" filter did not work for me, did I not do it right?