Clay Icon
Join the Community
02 Support

How to Split Comma-Separated Lists into Rows in Clay

Avatar of Ma. V.Ma. V.
·
·

Hi. I wanted to check with anyone, if it is possible to split a comma-separated list in a column into individual rows in Clay

6 comments

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    yes

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    Regex pattern: 

    (?<!\d)(\d+)(?!\d)

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·
  • Avatar of Ma. V.
    Ma. V.
    ·
    ·

    Awesome. Thank you for sharing.

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