Split String with Functions

[microwin88x]

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!

[Frank_Hartmann · Accepted solution]

see attached. hope this helps!