Help Required!

[Eug_teng]

Hi all,

I need some help this problem below:

Sample Input:

No.	Details
1	{"data":[{"code":"abc"},{"code":"bcg"}]}
2	{"data":[{"number":"27","code":"hkr"}]}
3	{"data":[{"number":"123","street":"alpha 3474"}]}
4	{"data":[{"street":"beta 2748","number":"789"}]}

Within the "Details" field, I have a complex string of data classified into various categories: code, number and street. I would like to extract these data and present these as individual columns. How do I go about doing this?

Sample Output:

No.	Details	code	number	street
1	{"data":[{"code":"abc"},{"code":"bcg"}]}	abc, bcg	null	null
2	{"data":[{"number":"27","code":"hkr"}]}	hkr	27	null
3	{"data":[{"number":"123","street":"alpha 3474"}]}	null	123	alpha 3474
4	{"data":[{"street":"beta 2748","number":"789"}]}	null	789	beta 2748

Thank you!

[afv2688 · Accepted solution]

Hello @Eug_teng ,

Does this look good to you?

Regards

[Eug_teng]

Yes thank you!