Hi everyone! @Qiu
I am trying to split a Jason file and count how many "Discount" words are in the string and how can I split them into columns.
the string is like below:
[{"$type":"OccurrenceDiscount","Occurrences":6,"AppliedCount":6,"AppliedOn":"2022-07-16T00:00:00","Cancelled":null,"CancelledStamp":null,"CancelledReason":null,"Discount":{"Value":165.0,"Type":0},"Reason":"Approved Mick - Timeframe Blow out","Started":"2022-01-18T00:00:00+11:00","StartedStamp":{"On":"2022-01-18T09:24:36.7940091+11:00","By":"TMOODLEY"}},{"$type":"OccurrenceDiscount","Occurrences":4,"AppliedCount":4,"AppliedOn":"2022-07-16T00:00:00","Cancelled":null,"CancelledStamp":null,"CancelledReason":null,"Discount":{"Value":163.9,"Type":0},"Reason":"rick","Started":"2022-03-19T00:00:00+11:00","StartedStamp":{"On":"2022-03-19T02:03:34.822948+11:00","By":"MWRIGHT"}}]
and finally, I want to get the amount of value into columns.
The string is in RecurringDiscounts_Data column.
would you be able to assist me with this?
Thanks,
Simon
