Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

regular expressions

Simon1187
9 - Comet

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?

 

 

 

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

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

Can you give a sample output?

Simon1187
9 - Comet

 @Qiu 

 

Thanks. 

 

Please check the files.

Qiu
20 - Arcturus
20 - Arcturus

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

0816-Simon1187.PNG

Labels