Split Contacts and Job Titles into Separate Columns by Company

Adam G. · 2024-09-11 00:18:10.338834+00

Hello. I have a result with a list of 5 names and job titles included in a single cell per company. Is there a way to break out each of the 5 new contacts and job titles in to separate columns per company?

Split Contacts and Job Titles into Separate Columns by Company | Clay

12 comments

· Sorted by Oldest

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). 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!
Bo (.
·
·
Hey, thanks for reaching out! 😊 Typically, you’d handle this with ChatGPT’s Generate Text and JSON mode, depending on how you’re structuring things. Could you clarify exactly what you’re trying to achieve? Also, it’s helpful to include an example of the JSON structure in your prompt to guide the process. Let me know if this approach works, or if you need any further assistance! 😊
Adam G.
·
·
Thanks. I'm researching who the top HR and Sales contacts are at fortune 1000 companies in the SF Bay area. I have the list but not in a an easy to use format. I should have told the AI how to return the results as you suggested.
Adam G.
·
·
i asked for the top 5 contacts at each F1000 company
Bo (.
·
·
Ok, I’ve extended your trial! Feel free to explore and play around 😊 You should now have 500 credits to use. Let me know if you need anything else!
Adam G.
·
·
Rad! Thank you! I will continue exploring!!! Greatly appreciated.
Channeled
APP
·
·
Hi Adam G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Adam G.
·
·
Hi there. I attempted to include a json formula to show how to present the results and am not getting the right output. here's a link https://app.clay.com/workspaces/259743/tables/t_U4W5MyycoTi9/views/gv_9wJzp2tYhGS2 Can you take a look and tell me what I need to do differently in order to get results were I have columns of first names, last names, and job title per company?
Bo (.
·
·
Claygent and ChatGPT work differently. Claygent Neon has more defined input specifications, while ChatGPT can transform text into JSON with its JSON mode, but it doesn’t format prompts the same way as Claygent. In this case, due to the recent update in Claygent, the results aren’t returned correctly, which leads to JSON errors in the ChatGPT column I added to show you the results, but you can still see the flow. I've also added some credits for you to play around. Let me know if you need any help in adjusting the inputs or formatting! 😊
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!
Channeled
APP
·
·
Hi Adam G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). 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!
Bo (.
·
·
Hey, thanks for reaching out! 😊 Typically, you’d handle this with ChatGPT’s Generate Text and JSON mode, depending on how you’re structuring things. Could you clarify exactly what you’re trying to achieve? Also, it’s helpful to include an example of the JSON structure in your prompt to guide the process. Let me know if this approach works, or if you need any further assistance! 😊
Adam G.
·
·
Thanks. I'm researching who the top HR and Sales contacts are at fortune 1000 companies in the SF Bay area. I have the list but not in a an easy to use format. I should have told the AI how to return the results as you suggested.
Adam G.
·
·
i asked for the top 5 contacts at each F1000 company
Bo (.
·
·
Ok, I’ve extended your trial! Feel free to explore and play around 😊 You should now have 500 credits to use. Let me know if you need anything else!
Adam G.
·
·
Rad! Thank you! I will continue exploring!!! Greatly appreciated.
Channeled
APP
·
·
Hi Adam G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Adam G.
·
·
Hi there. I attempted to include a json formula to show how to present the results and am not getting the right output. here's a link https://app.clay.com/workspaces/259743/tables/t_U4W5MyycoTi9/views/gv_9wJzp2tYhGS2 Can you take a look and tell me what I need to do differently in order to get results were I have columns of first names, last names, and job title per company?
Bo (.
·
·
Claygent and ChatGPT work differently. Claygent Neon has more defined input specifications, while ChatGPT can transform text into JSON with its JSON mode, but it doesn’t format prompts the same way as Claygent. In this case, due to the recent update in Claygent, the results aren’t returned correctly, which leads to JSON errors in the ChatGPT column I added to show you the results, but you can still see the flow. I've also added some credits for you to play around. Let me know if you need any help in adjusting the inputs or formatting! 😊
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!
Channeled
APP
·
·
Hi Adam G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: