Viewing 2 posts - 1 through 2 (of 2 total)
- Posts
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!
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.urlSee the screenshot.
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.