Hi every one,
I'm having a text string as example:
{"Status":"Active","updatedBy":"lynn123","hasAccount":false}
What I expect to have is:
Status: Active
updatedBy: lynn123
hasAccount: no
I think for replacing comma with a line-break, char(10) might work, then I will substitute false with "no". But for the rest of characters {,},"", I'm not sure how to remove them all at once. I checked documentary for a!stripWith or a!reject and I think they don't work with a list of characters.
Hope I can have some suggestions from you,
Thanks a lot!
Discussion posts and replies are publicly visible
This looks like a JSON string. Why not just use fromJson() to turn it into a dictionary and then use normal Appian functionality to display the values?
After applying fromJson, I get this string: [Status:Active,updatedBy:,hasAccount:false]. Not sure what is it's data type as I did this in a forEach loop for every row of my grid column.
Could you explain more of the normal Appian functions that you mentioned? What I could think of is:
substitute( stripwith( "[Status:Active,updatedBy:,hasAccount:false]","[", ), ",", char(10))
However stripWith only allow 1 character so I missed the "]", also I couldn't have the line break as expected.
The result of my work is:
"Status:Active updatedBy: hasAccount:false]"(Text), in which "]" has not yet been removed.
fromJson does NOT return a string, but a dictionary containing key-value pairs. Appian does display it as a string.
You can then access the fields using dot-notation or index()/property(). Check the Appian documentation for how to do this.