# Query JSON - quotation marks

**URL:** <https://community.glideapps.com/t/query-json-quotation-marks/65362>\
**Category:** Ask for Help\
**Created:** [August 24, 2023, 9:07pm UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362 "2023-08-24T21:07:02Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 27, 2023, 5:01pm UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/10 "2023-08-27T17:01:19Z")

</div>

yes I think something was changed from some JSONata library

I used to receive the data like:

> Aug 18, 2023, 10:13:31 PM|#83a7b|Olguita|555000|0412-555000|olga@dsados.com|Qta Olga, maracay edo. aragua|- (1) RISOTTO ALL’ARAGOSTA: US$9.60|US$9.6|N/A|

but now I have the same data wrapped in quotes 🥴

> **"** Aug 18, 2023, 10:13:31 PM|#83a7b|Olguita|555000|0412-555000|olga@dsados.com|Qta Olga, maracay edo. aragua|- (1) RISOTTO ALL’ARAGOSTA: US$9.60|US$9.6|N/A| **"**

My workaround to remove these quotes (at the beginning and at the end) was using a JS code (@Adam_Crossley):

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8ba1c7d49ccbd242f2a024c7f4bb1e54753a6ace.png)

```auto
let lon= p1.length
return p1.substring(1, lon-1)

```

I hope it helps meanwhile

Saludos!

---

_[View the full topic](https://community.glideapps.com/t/query-json-quotation-marks/65362)._