Parse Claygent Output into Separate Columns Without Credits

Hi I'm trying parse the data from this claygent output into separate columns without using credits. From this raw claygent output:

{"company_name": "< Festo Limited >", "registration_number": "< 926749 >", "charge": {"date_created": "2021-01-26", "person_entitled": "National Westminster Bank PLC", "status": "Outstanding", "description": "Contains fixed charge"}}

I want to have a column for only:

Company Name
Registration Number
Date created
Person Entitled
Status
Description

Is this possible without using credits?

12 comments

Channeled
APP
·
·
Yes, you can parse and organize Claygent output data into separate columns without using any credits. Our data cleaning and formatting tools are completely free to use.You can use our Extract Values feature to pull specific information from your data and organize it into separate columns. Additionally, you can normalize and standardize the extracted data to ensure consistency across all entries.The process is credit-free since these functions only involve parsing existing data and executing code, rather than reaching out to external data providers. Sources: Data Cleaning + Normalization [CRM Enrichment] - Clay University Normalize and Deduplicate a List with Clay Credits Calculator | Clay.com Extract Values from Data with Clay
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Bruno R.
·
·
Hi Eugene, thanks for reaching out. Taking a look at this now!
Bruno R.
·
·
Eugene - Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1734428700&signature=fa15bc464aaa5f8fc70d7b0742cd54b65420cf79019b946986ee451e6b3e89f5&req=dSEgF85%2FmohWX%2FMW1HO4zYTywS%2F4BJ8R2BKsam%2FhVPvFvQ%3D%3D%0A
Eugene A.
·
·
https://app.clay.com/workspaces/394562/workbooks/wb_SieXUqaXCRY4/tables/t_fYGdyB28hNgy/views/gv_NphWMQingHad
Eugene A.
·
·
Thanks Bruno
Bruno R.
·
·
Adding 100 credits back to your account as I'm testing a prompt setup which should parse the outputs automatically to the columns you're outlining here!
Bruno R.
·
·
Just recorded this video to show you how I'd go about this: https://www.loom.com/share/6e4f300e7e0f451c8596d9056bac93ba?sid=be307a3b-bf5c-4c86-bfb3-c0492b360d8d. I hope this was helpful. If there's anything else I can assist you with, please let me know!
Eugene A.
·
·
Wow amazing! Thanks so much Bruno!
Bruno R.
·
·
Happy to help Eugene!
Channeled
APP
·
·
Hi Eugene A.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Eugene A.!