How to escape the "\" escape character itself?

[Antony_Chan]

Dear community,

I'm trying to use the replace command in XQL to replace the "\" escape character and have so success.

When I tried with the double slash \\, the XQL will raise syntax error.

| alter test2 = replace(to_json_string(data), "\\", "")

Sample data:

["{\"ActionType\":\"Forward\",\"Recipients\":[\"john.doe@domain.com\"],\"ForwardFlags\":\"None\"}"]

 
Expected output:

["{"ActionType":"Forward","Recipients":["john.doe@domain.com"],"ForwardFlags":"None"}"]

Thank you in advance.
Cortex XDR