topic Parse After Colon in DQL

Parse After Colon

jacob_norkus — Wed, 18 Oct 2023 14:22:26 GMT

Hey Team, how do we parse data after a colon? For example here is a snippet from the log

"mvcLastloginTimestamp":"1697106375080","thisCustomerNum":"123456789","objectClass":

We're looking to parse out the customerNum without the beginning ":" and ending quote.
The following parse command includes the colon and ending quote

| Parse content, "LD 'thisCustomerNum' LD:ID ',' "

I can't seem to get the syntax just right to avoid the colon and ending quote. Thanks in advance!

Re: Parse After Colon

gbaudart — Thu, 09 Nov 2023 08:36:55 GMT

Hi
Do you have test this :

| parse content,"LD 'thisCustomerNum\":\"' LD:ID '\",' "

Let me know if this works

Re: Parse After Colon

gbaudart — Tue, 14 Nov 2023 12:56:25 GMT

@jacob_norkus , Were you able to test my suggestion?