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!
Solved! Go to Solution.
Yes thank you!