HOW TO: Avoid URL encoding of special characters

While this formula works if you don't have special characters like apostrophes in your values:

 {{trim (split supervisor "," 1)}} {{split supervisor "," 0}}

that doesn't help when dealing with more complex values, like O'Shanahan, as it will render the hex value for the apostrophe (Edward O'Shanahan). {{ }} will URLencode any URL-encodable characters, while {{{ }}} will remove the URL encoding. In this case, use

{{trim (split supervisor "," 1)}} {{{split supervisor "," 0}}}, 

which will give you Edward O'Shanahan.