Extract data from complex JSON with regular expressions

[Paul_Danyliuk]

@Paul_Danyliuk

It would be awesome if the path parameter supported queries like JSONPath — but it feels like it doesn’t:

Reviving this thread to say it’s not true anymore — ParseJson supports JSONPath now!
No more regexes to parse JSON.

How to extract @People and other @-references from a Text cell

A client asked me today how he could take a text field like this and extract people from it: [image] The “straightforward” ideas like using Split didn’t work. Links and @-references in formatted text are unlike the rest of the text: technically they occupy just one empty character and instead have an extended encoded descriptor telling what should be displayed in place of that empty character. Running a formatted text field through just strips those descriptors and that’s what you get: [imag…