JsonUnescape - SQLHTTP

RegexUnescape

Returns a Json un-escaped string

Syntax:

SELECT SQLHTTP.net.JsonUnescape ( @JsonValue )

Arguments:

Name	Type	Description
@JsonValue	nvarchar(MAX)	Json Value to un-escape.

Return Type:

nvarchar(MAX)

Remarks:

Json un-escaping IS always identical to Regex un-escaping, but Json escaping is NOT always identical to Regex escaping.

Sample Usage:


DECLARE @JsonValue nvarchar(MAX)
 
SET @JsonValue = '\"C:\\temp\"'
 
SELECT SQLHTTP.net.JsonUnescape(@JsonValue)

DECLARE @JsonValue nvarchar(MAX)

SET @JsonValue = '\"C:\\temp\"'

SELECT SQLHTTP.net.JsonUnescape(@JsonValue)

---------------

"C:\temp"