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!
