Hello,
I have the following string:
[{"id":"500","program":"prog003","number":"333525","datetime":"2017-01-03 15:45:15","zone":"north","amount":"100"}, {"id":"501","program":"prog003","number":"333526","datetime":"2017-01-03 15:48:30","zone":"north","amount":"300"}, {"id":"502","program":"prog003","number":"333527","datetime":"2017-01-03 17:25:23","zone":"south","amount":"150"}]
Is there any way to split it with string functions by script so I could have the following?
| id | program | number | datetime | zone | amount |
|---|
| 500 | prog003 | 333525 | 2017-01-03 15:45:15 | north | 100 |
| 501 | prog003 | 333526 | 2017-01-03 15:48:30 | north | 300 |
| 502 | prog003 | 333527 | 2017-01-03 17:25:23 | south | 150 |
Thank you!
