i wish to replace/substitute "[", "]" with " " in string received below
""param":[{"key1":"value1","key2":"value2"}, {"key3":"value3","key4":"value4"}]"
substitute(""param":[{"key1":"value1","key2":"value2"}, {"key3":"value3","key4":"value4"}]","["," ")
substitute(""param":[{"key1":"value1","key2":"value2"}, {"key3":"value3","key4":"value4"}]","]"," ")
I am receiving the below error
can someone help me understand the error here.
Discussion posts and replies are publicly visible
Each and every item under " " is considered as a separate string. That's why you are getting error which says signature length does not match.
One more thing you can do here is to convert your parameter into string first, Like below
substitute(tostring(""param":[{"key1":"value1","key2":"value2"}, {"key3":"value3","key4":"value4"}]"),"["," ")
Tried it No Good result vivek. it is returning null.
your input string still isn't formatted properly. the proper way to create double-quotes inside an Appian string is to put 2 sets of double quotes. this added to needing single-quotes surrounding your string. it gets pretty confusing. you might try inserting your desired string value as the "value" portion of an input parameter and seeing what happens then.
as far as i can tell, this should work:
local!string: """param"":[{""key1"":""value1"",""key2"":""value2""}, {""key3"":""value3"",""key4"":""value4""}]"
actually tried that it didn't work
seems to work for me - remember you need to enclose your local variable in with() or load() or a!localVariables() which it looks like you may have missed. here's my result:
and here's my code:
with( local!string: local!string: """param"":[{""key1"":""value1"",""key2"":""value2""}, {""key3"":""value3"",""key4"":""value4""}]", substitute(local!string, "[", " ") )