SQLite Forum

Is there a json_unquote()?
Login
Hierarchical

Is there a json_unquote()?

(1) By Paul van Helden (paulvh) on 2020-05-22 12:51:27 [link] 

..to use a JSON string returned from the json functions?

(2) By Richard Hipp (drh) on 2020-05-22 13:06:20 in reply to 1 

The [json_extract()][1] function should return an unquoted string when the
PATH argument refers to a string value.

[1]: https://www.sqlite.org/json1.html#the_json_extract_function

(3) By Paul van Helden (paulvh) on 2020-05-22 13:29:18 in reply to 2 [link] 

OK, thanks, but I've made my own json_unquote now so that I can use it on a return value from another json function. I think this would be a sensible addition?