Query JSON - quotation marks

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 :woozy_face:

" 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

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

I hope it helps meanwhile

Saludos!

2 Likes