Parsing Data

[SteveFord]

Hey all,

I have a dataset that has one column with a long sting of text as per the file upload. I need to parse the data out in to columns as below (I only need those fields) so the column name is the field name and values as in the text answers:

"phone_field": ["19148475887"]

"postcode_field": ["10591"]

"country_field_gen": ["United States"]

"jobtitle_field": ["Compliance Counsel"]

"email_field": ["brooke.sherer@regeneron.com"]

"company_name_field": ["Regeneron Pharmaceuticals"]

"surname_field": ["Sherer"]

"firstname_field": ["Brooke"]

"thirdparty_consent_field": ["Consent Not Asked"]

[usmanbashir]

@SteveFord - please see attached workflow. Hope this helps!

[SteveFord]

Sorry, if you look at the file uploaded the text comes in one column in a big long string. I need that parsed out to columns.

[usmanbashir]

@SteveFord - sorry misread. Here you go!

**disregard this message - wrong workflow attached

[adamweaver39 · Accepted solution]

Hey @SteveFord , including my workflow that specifically works with your file. Hope this helps. Probably a more elegant solution out there, but this solution seems parsable!

[usmanbashir · Accepted solution]

@SteveFord - apologies - I previously attached the wrong workflow. Here you go. The data is just JSON so you can you JSON parse. See attached workflow.