We have the need to decode a string from a HTTP webhook using UTF-8 encoding.
input string: "test product%27s name"
output after decoding should be: "test product's name"
we've tried [IPN.PNAME].gsub(/%\w+/,{'%27' => '''}) but it throws a formula error.
The below formula will give you the expected output:
[IPN.PNAME].gsub(/:[^%]|%[0-9A-Fa-f]{2}/,{'%27' => "'"})
Send us a ticket, we will try our best to assist you with your problem
Amber Veatch
using gsub to decode utf-8 encoded string
We have the need to decode a string from a HTTP webhook using UTF-8 encoding.
input string: "test product%27s name"
output after decoding should be: "test product's name"
we've tried [IPN.PNAME].gsub(/%\w+/,{'%27' => '''}) but it throws a formula error.