regular expressions

[Simon1187]

Hi everyone! 

@ArtApa ,
@Qiu 

I would like to split the string into rows. 

For example, the string is below:

when you get this   "}},{ 

then I want to insert it in the row below.

[{"AppliedCount":39,"AppliedOn":"2022-08-10T00:00:00","Cancelled":null,"CancelledStamp":null,"CancelledReason":null,"Discount":{"Value":50.0,"Type":0},"Reason":"Customer signed up 4 locations and provided refferals","Started":"2019-05-18T00:00:00+10:00","StartedStamp":{"On":"2019-05-18T12:26:37.412169+10:00","By":"TVAN-EYK"}},{"$type":"OccurrenceDiscount","Occurrences":6,"AppliedCount":6,"AppliedOn":"2020-09-10T00:00:00","Cancelled":null,"CancelledStamp":null,"CancelledReason":null,"Discount":{"Value":112.5,"Type":0},"Reason":"CS x approved by tony","Started":"2020-04-06T00:00:00+10:00","StartedStamp":{"On":"2020-04-06T12:53:05.3538218+10:00","By":"SNICHOLS"}},{"$type":"OccurrenceDiscount","Occurrences":2,"AppliedCount":2,"AppliedOn":"2021-10-10T00:00:00","Cancelled":null,"CancelledStamp":null,"CancelledReason":null,"Discount":{"Value":112.5,"Type":0},"Reason":"Approved Tony","Started":"2021-08-12T00:00:00+10:00","StartedStamp":{"On":"2021-08-12T12:10:48.712533+10:00","By":"TMOODLEY"}},{"$type":"OccurrenceDiscount","Occurrences":1,"AppliedCount":1,"AppliedOn":"2021-09-10T00:00:00","Cancelled":null,"CancelledStamp":null,"CancelledReason":null,"Discount":{"Value":112.5,"Type":0},"Reason":"Approved Tony","Started":"2021-08-12T00:00:00+10:00","StartedStamp":{"On":"2021-08-12T12:10:59.0856728+10:00","By":"TMOODLEY"}}]

would you be able to assist me with this?

[Qiu]

@Simon1187 
I am sorry but I did not quite get what you need.

Can you give a sample output?

[Simon1187]

 @Qiu 

Thanks. 

Please check the files.

[Qiu · Accepted solution]

@Simon1187 
I assume the "}}," is the breaking point, so I replace it to "}}|" and use the "|" as delimiter.