I am using a nested replace function to strip out some json tags but Make seems to be inserting a + character into the function so the output is not as expected.
This is the module configuration:
This is what the configuration looks like from the run history:
Any idea what the issue is? I’ve tried various combinations of escaping the braces with no luck.
Hi @Automation_User - the formula doesn’t look right, the first replace() is missing a ; semicolon after emptystring) and this part: ,{“URLs”\[{}\]} isn’t valid JSON so it shouldn’t be in the output string at all.
Your string likely contains something like {”URLs”:[{}]} - that’s what you need to put in the replace function, no escaping necessary because replace() looks for text by default, it’s not a regex parser.
So try this:
{{replace(replace(JSONString; ",{}"; emptystring); "{""URLs"":[{}]}"; emptystring)}}
Or if the JSON string output puts a space between "URLs”: and [{}] you’ll need to include that in the formula:
{{replace(replace(JSONString; ",{}"; emptystring); "{""URLs"": [{}]}"; emptystring)}}
If this won’t work, can you share the output of your JSON parse module (at least the part you’re trying to replace)?
Cheers
Thankyou, definitely a case of assuming it is complicated and missing the simple mistake
