I am looking for guidance on splitting column into multiple columns.
I am trying to split semi-colon delimited text into separate columns. Using the AI formula generator times out when I follow the CSV example. Any thoughts?
👋 Hey there! Our support team has got your message - we'll be back in touch soon. If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Sure thing. Here is my table URL.
Hey, thanks for reaching out! 😊 Your best approach is to use ChatGPT with JSON mode activated and mention JSON in your prompt. For example, you could say, “Extract the JSON of this /column.” Y You can also extract values from data using these steps: 1. Add the enrichment by clicking the “Add Enrichment” button in the enrichment panel (top right of the page). 2. Use a forward slash (”/”) to add the column in the data. 3. Select Custom. 4. Add this Regex: [^\s,]+ 5. Run it. This will give you unique columns. If you encounter quotation marks in the JSON, go into the settings of those columns and use aformula to remove them. Let me know if you need any more guidance! 👍
I'm trying to avoid hitting OpenAI or using a Clay credit to split the text apart.
I'm trying to split semi-colon delimited text. Using that regex, it's not splitting properly. I'm trying to use ChatGPT to generate the correct regex, but I'm pretty rusty on them. Any ideas?
Hey Bill, I noticed a few changes and took some time to check and update the prompt with Claygent. I’d also suggest removing some selection options, but you can still force Claygent to return specific outputs (ideally 3-4) for better accuracy. I added all of them in there for now. Adding too many values can cause confusion and lead to more hallucinations, which is something to avoid. The way I set it up ensures all values will be returned as individual rows for easy processing. More details on what I used: Claygent Let me know if you need any further adjustments! 😊
There's Claygent Neon which might help understanding more. It is our own AI model, but for Claygent and your API Key, it’s essentially just about adding clear output. 😊 Think of it as an add-on to enhance your prompt! Let me know if you need more details! 🙂
This is very helpful. I understand the proper use of Claygent much better now. I appreciate the help!
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!