Split String with Functions

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Split String with Functions

Frank_Hartmann — Sat, 18 Mar 2017 17:13:50 GMT

see attached. hope this helps!

topic Re: Split String with Functions in QlikView

Split String with Functions

Re: Split String with Functions