Need help on string conversion

, ,
1

Hi All,
I have a string like below which is dynamic which is coming as one of the steps of my flow service.

String1:
{“Values”:[“{ROLE_ID=14, ROLE_NAME=Service Owner, Description=??? ???}”,
“{ROLE_ID=15, ROLE_NAME=Service User, Description=??? ???}”,
“{ROLE_ID=16, ROLE_NAME=Service Provider, Description=??? ???}”]}

I need the output like below

{“Values”:[{“ROLE_ID=14, ROLE_NAME=Service Owner, Description=??? ???”},
{“ROLE_ID=15, ROLE_NAME=Service User, Description=??? ???”},
{“ROLE_ID=16, ROLE_NAME=Service Provider, Description=??? ???”}]}

String2:

{“Values”:[“{CATEGORY_ID=118, PARTY_TYPE=1, PARTY_TYPE_NAME=CORPORATE, ROLE_CATEGORY=BRANCH NU}”,
“{CATEGORY_ID=119, PARTY_TYPE=1, PARTY_TYPE_NAME=CORPORATE, ROLE_CATEGORY=PRODUCT NU}”]}

I need the output like below

{“Values”:[{“CATEGORY_ID=118, PARTY_TYPE=1, PARTY_TYPE_NAME=CORPORATE, ROLE_CATEGORY=BRANCH NU”},
{“CATEGORY_ID=119, PARTY_TYPE=1, PARTY_TYPE_NAME=CORPORATE, ROLE_CATEGORY=PRODUCT NU”}]}

Can someone help how to get this ?

Thanks,
Anil.

2

Replace string or regex (bit complex) should do it. Did you try?

3

Thanks for your reply. I tried those options but not working, did you try with any ex ?

Thanks,
Anil

4

Are you sure? See attached
Capture.JPG

5

See attached

6

Thanks for your reply. I tried those options but not working, did you try with any ex ?

Thanks,
Anil

7

Use stringReplace steps one by one for different patterns that are identified for desired output.