topic Re: Nested quotation marks in DQL

Nested quotation marks

eriknois — Wed, 06 Dec 2023 15:32:40 GMT

Hello, I am trying to parse two values from the content field, but ran into a problem with quotation marks.

Here's a shortened version of the record:
content:{"contextMap":{"id:"a1","details":["description":"amount","grossAmount":20,

My parse without double quotation marks looks like this and only results in a null return value:
| parse content, "LD 'description' WORD:description, LD 'grossAmount' INT:grossAmount"

If I change it to include the double quotes it breaks the query:
| parse content, "LD 'description":"' WORD:description, LD 'grossAmount":' INT:grossAmount"

How can I use double quotes without breaking the parse query?

Re: Nested quotation marks

sinisa_zubic — Wed, 06 Dec 2023 17:34:40 GMT

Hi @eriknois

You can use triple quotes

data record(content="""content:{"contextMap":{"id:"a1","details":["description":"amount","grossAmount":20]""") | parse content, """LD '"description":' DQS:amount ',"grossAmount":' INT:grossAmount"""

Best,
Sini

Re: Nested quotation marks

eriknois — Thu, 07 Dec 2023 08:07:54 GMT

Great, thank you for the quick reply!