ESCAPEDOUBLEQUOTE function

The ESCAPEDOUBLEQUOTE function helps you to ignore the double quotes that are typically present in JSON type data returned by the server or by advanced controls like Form Repeat control, Summary control, and so on. By escaping double quotes you can process the JSON values as valid data for any further processing like say inserting data into SQL Database.

Syntax

ESCAPEDOUBLEQUOTE(string/text/json value)

Where,

  • <string/text/json value>: is the JSON value returned by APIs or control selections

Example

ESCAPEDOUBLEQUOTE( [{“productname2”:“Laptop”,“quantity1”:101}])

Returns

[{“productname2”:“Laptop”,“quantity1”:101}]

To know more about how to use the ESCAPEDOUBLEQUOTE function refer this article here.