JSON character escaping function in classic ASP
If you are into advanced AJAX techniques you probably will stumble across JSON (www.json.org) which makes developing (and therefore the life) a lot easier when working with AJAX. If you already stumbled across and you use JSON within classic ASP you might find this article useful. It deals with escaping characters for JSON acording to the RFC4627#2.5
I haven't found any snippet out there for classic ASP so we had to write our own. And so my work colleague - an old algorithm guru - just came up with this function which covers all the requirements specified in the JSON RFC.
What we want to achieve...
-
<script>
-
alert({foo:"<%= "some va""lue" %>"}.foo);
-
</script>
The code snippet above will result in a javascript error because we are passing an apostrophe from ASP to Javascript which leads to an early closing of the string: foo:"some va"lue" (there is one apostrophe too much). The same thing happens for other characters as well. If you have line breaks, german umlaute, hidden special characters, etc. All those need to be escaped now in order that the javascript simple object notation (JSON) can interpret it. Thats the function which does the escaping (there are 3 more functions cause they're used within the escapeJSON()):
-
'******************************************************************************************
-
'' @SDESCRIPTION: takes a given string and makes it JSON valid (http://json.org/)
-
'' @AUTHOR: Michael Rebec
-
'' @DESCRIPTION: all characters which needs to be escaped are beeing replaced by their
-
'' unicode representation according to the
-
'' RFC4627#2.5 - http://www.ietf.org/rfc/rfc4627.txt?number=4627
-
'' @PARAM: val [string]: value which should be escaped
-
'' @RETURN: [string] JSON valid string
-
'******************************************************************************************
-
public function escapeJSON(val)
-
cDoubleQuote = &h22
-
cRevSolidus = &h5C
-
cSolidus = &h2F
-
-
for i = 1 to (len(val))
-
currentDigit = mid(val, i, 1)
-
if asc(currentDigit)> &h00 and asc(currentDigit) <&h1F then
-
currentDigit = escapeJSONSquence(currentDigit)
-
elseif asc(currentDigit)>= &hC280 and asc(currentDigit) <= &hC2BF then
-
currentDigit = "\u00" + right(padLeft(hex(asc(currentDigit) - &hC200), 2, 0), 2)
-
elseif asc(currentDigit)>= &hC380 and asc(currentDigit) <= &hC3BF then
-
currentDigit = "\u00" + right(padLeft(hex(asc(currentDigit) - &hC2C0), 2, 0), 2)
-
else
-
select case asc(currentDigit)
-
case cDoubleQuote: currentDigit = escapeJSONSquence(currentDigit)
-
case cRevSolidus: currentDigit = escapeJSONSquence(currentDigit)
-
case cSolidus: currentDigit = escapeJSONSquence(currentDigit)
-
end select
-
end if
-
escapeJSON = escapeJSON & currentDigit
-
next
-
end function
-
-
function escapeJSONSquence(digit)
-
escapeJSONSquence = "\u00" + right(padLeft(hex(asc(digit)), 2, 0), 2)
-
end function
-
-
function padLeft(value, totalLength, paddingChar)
-
padLeft = right(clone(paddingChar, totalLength) & value, totalLength)
-
end function
-
-
public function clone(byVal str, n)
-
for i = 1 to n : clone = clone & str : next
-
end function
So now we should be able to escape the strings for JSON like this and no error should occur...
-
<script>
-
alert({foo:"<%= escapeJSON("some va""lue") %>"}.foo);
-
</script>
This stuff has been tested and works for all characters so everything can be transfered with JSON now ;) I would suggest to group the whole functions into a class called JSON with a method escape() just for a nicer use. In my case its in a utility class StringOperations where I have several string manipulation methods. If you are interested you can download the full String class also which include the JSON escaping method:
StringOperations 0.9 (StringOperations Documentation)
(16 votes, average: 4.06 out of 5)
Loading ...
Michal: "Hi Sean, you might be interested in http://groups.google.com/gr..."
Sean: "Michal, Is it possible to use ajaxed wth jquery instead of prototype ? If no, would it..."
Sam: "Two things: – I found two ASP libraries and couldn’t decide if either had..."
Tony: "Hi Sam, Could you make it public, so we can test (and use ;-)) it?"
Bren: "Hey Michal, Are there any plans to restart Jelly in BKK? I’m very interested in..."
Mato: "Here’s a piece of PHP code, that I use to generate 1×1px jpeg image. You can..."
Gellert: "Hi, Great idea.. thanks… now I know what i need blogs for. I think my life will..."
Thanks a ton! I was going crazy coz wasn't finding one suitable solution for ASP. Thanks again!
Hi Michal,
I'm having a problem converting the string back to special characters. When I get data from JSON and the strings are escaped, and I need to put that data into a form field the \uuxx numbers are still there instead of the special characters. Do you have, or know of any function that reverses this process?
Erik
I rate this code: FLUNK.
Your code:
- Escapes characters unnecessarily (such as forward slash).
- Escapes using more characters than needed, making the JSON longer (using hex notation instead of simple backslash-escaping).
- Escapes every high Ascii character as \u00__ which is not only longer than \x__ but completely ignores the first byte of Unicode characters, making the result meaningless.
- Has goofy stuff like "- &hC2C0" which is clearly an undefined operation to perform on Unicode between &hC380 and &hC3BF. Perhaps you're matching character sets to character sets, but this is something you're supposed to solve with fonts, not subtraction to turn one code into another. To make your preposterous claim "This stuff has been tested and works for all characters so everything can be transfered with JSON now" valid, you have to rip out this junk. I don't care how elaborate a character map you use, you'll still be altering characters, hardly the desire of most people who want to send Unicode characters through JSON from ASP.
Here is my version:
[asp]Function JSONEscape(json)
Dim Pos
Dim Char
Dim Code
JSONEscape = ""
If IsNull(json) Then Exit Function
For Pos = 1 To Len(json)
Char = Mid(json, Pos, 1)
Code = AscW(Char)
If (Code >= 32 And Code <= 127) And Code 34 And Code 39 And Code 60 And Code 92 Then 'printable, plus skip '"\ and to avoid false HTML tags 0 Then
JSONEscape = JSONEscape & "\" & VBA.Mid("bfnOrtv'""\", Code, 1)
Else
Code = AscW(Char)
If (Code >= 0 And Code <= 255) Then 'escape nonprinting, high ascii, and < characters (to avoid false HTML tags)'
JSONEscape = JSONEscape & "\x" & VBA.Right("0" & Hex(Code), 2)
Else
JSONEscape = JSONEscape & "\u" & VBA.Right("000" & Hex(Code), 4)
End If
End If
End If
Next
End Function[/as]
For want of a preview function, a p was lost :) ...
And the second comment in the last If statement should be removed. It is a leftover after reordering the code to hit most likely conditions first in the loop.