Replacing / escaping special characters to be used for JSON

I have a process that is generating some JSON that is used with a Download tool (using POST HTTP action) to update a database via an API. All is good except there is a required field that has some data that may have special characters in it. I need to replace those special characters with valid escape characters for JSON. I found some documentation about what is valid, but I don't see an easy way to do this. I saw something like this in a tool that escapes special characters for XML, but I don't think that will work.

Does anyone have a handy way to do this? Maybe with some Regex (I don't know Regex, but this seems like a good use case)?

Regex

Preparation

Expression

Accepted answers

Joe_Mako

Using the list from https://mathiasbynens.be/notes/javascript-escapes

How about something like this:

IF IsNull([String]) THEN '\0' ELSE
Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([String], 
CharFromInt(92),'\\'),
CharFromInt(12),'\f'),
CharFromInt(10),'\n'),
CharFromInt(13),'\r'),
CharFromInt(9),'\t'),
CharFromInt(11),'\v'),
CharFromInt(39),"\'"),
CharFromInt(34),'\"'),
CharFromInt(8),'\b')
ENDIF

All comments

Joe_Mako

Using the list from https://mathiasbynens.be/notes/javascript-escapes

How about something like this:

IF IsNull([String]) THEN '\0' ELSE
Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([String], 
CharFromInt(92),'\\'),
CharFromInt(12),'\f'),
CharFromInt(10),'\n'),
CharFromInt(13),'\r'),
CharFromInt(9),'\t'),
CharFromInt(11),'\v'),
CharFromInt(39),"\'"),
CharFromInt(34),'\"'),
CharFromInt(8),'\b')
ENDIF

michael_hartmann1

@Joe_Mako - thanks! I just tried that. It looks as if your formula worked like a champ.

Unfortunately, the post via the API failed from that. I have a request in with the vendor of that API to get some clarification on how to handle...maybe they have a special case. But, I think your solution should work well.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703