Clay Icon

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?

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

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Thank you so much for sharing your feedback AJ C.!

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

  • Avatar of Jacob T.
    Jacob T.
    ยท
    ยท

    AJ C. if you have any more questions/need help, please don't be a stranger!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Could you provide more details about the specific output format you're aiming for in your Claygent results?

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

  • Avatar of AJ C.
    AJ C.
    ยท
    ยท

    Question

  • Avatar of AJ C.
    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?