Hi All,
I have string containing items, such as ["var1","var2"] and there might be more than two items, I want to extract these values without double quotation marks " and square brackets [ ] , the result should be like var1,var2
are there any functions that could help me achieve this?
Discussion posts and replies are publicly visible
stripwith(ri!input, "[]""")
https://docs.appian.com/suite/help/23.4/fnc_text_stripwith.html
Are you sure that's not a JSON string? If so, you should use supported functionality to just convert it back from JSON to an array.
Hello alaaa6815 Assuming that this is JSON format. as Mike mentioned you can try using the supported functionality.
alaaa6815 said:["var1","var2"]
Check out this example on how it would work a!fromJson() Function (Example)
If you are getting this String as a response from one of your integrations, I will advise you to look for this option in your integration -
Did you try the extract() function? https://docs.appian.com/suite/help/23.4/fnc_text_extract.html