Clay Icon

Extracting and Organizing Numbered Sections for Analysis

Β·
Β·

How can I extract and reorganize numbered sections, like "1." and "2.", in a text to divide and classify them by distinct points in differents columns (e.g., "1.", "2.") for further processing or analysis? as an exemple, i would like to reorganise each part of the answer into differents columns :

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    πŸ’€ You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Summiya B.
    Summiya B.
    Β·
    Β·

    @aalexandre paillierpro go to edit coloumn section and in the body part enter return result in json format ..and then add json format.you will get organized data.

  • Avatar of Bo (.
    Bo (.
    Β·
    Β·

    Hi there! You can reorganize and classify text sections like β€œ1.”, β€œ2.”, etc., into different columns using Clay’s AI formulas. This allows you to extract each part of the text and place it into distinct columns for easier processing and analysis. You can find a helpful guide on how to do this here: How to Use AI Formulas in Clay. For pre-enrichment next time Summiya is right, you can also use JSON mode to specify outputs if needed and/or simply specify the ouputs at the bottom of the enrichment Let me know if you need any further assistance! 😊

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

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