[Marc Schlaeppi]

Hello,

I would like to parse a column which has json data and expand that into new columns. Is this feasible? How would one go about this?

https://ibb.co/P9JPkfm – Sample Data

I am trying to achieve something like this – https://support.microsoft.com/en-au/office/parse-text-as-json-or-xml-power-query-7436916b-210a-4299-83dd-8531a1d5e945

Thank you for your time and help!

[David]

Yes. It’s possible in Emeditor by \J or \V mode. I can’t catch your data, then use a simple JSON data as the following:

Sample Data:

{“name”:”Runoob”, “url”:”www.runoob.com”}
{“name”:”Google”, “url”:”www.google.com”}
{“name”:”Taobao”, “url”:”www.taobao.com”}

Find: ^.+$
Replace: \V a=JSON.parse(‘\0’); a.name + ‘\t’ + a.url

See the screenshot.

[Author]

Posts