topic Re: Parse log data to return full name that has spacing in DQL

Parse log data to return full name that has spacing

Maelam — Wed, 18 Oct 2023 13:14:21 GMT

Hi there,

How can parse this content data to include the full name which has a space? here's the content below:

2023-10-18 13:01:54,750 [ajp-apr-8109-exec-12] ERROR csc.fs.stp.ota.lib.action.OverrideSystemErr- Line: 29 [(OTAActionServlet.java:228) : Error while updating Banking details of Full Name:Maela Matlapu AccountNumber:22222222 BranchCode:000000 AccountType:Current error : csc.fs.FSServerException (1 details) B911 BANK DETAIL VALIDATION ERROR ]

fetch logs, from:-24h, to:-2h

| filter loglevel == "ERROR" and contains(content, "BANK DETAIL VALIDATION ERROR")
| parse content, "ld 'Name:' string:Name ld 'AccountNumber:' string:AccountNumber"

Re: Parse log data to return full name that has spacing

sinisa_zubic — Wed, 18 Oct 2023 13:32:05 GMT

Hi @Maelam

Can you try if this works

fetch logs, from:-24h, to:-2h | filter loglevel == "ERROR" and contains(content, "BANK DETAIL VALIDATION ERROR") | parse content, """ld 'Name:' LD:name ' AccountNumber:' string:AccountNumber"""

Best,
Sini

Re: Parse log data to return full name that has spacing

Maelam — Wed, 18 Oct 2023 13:44:55 GMT

Thanks a lot, that works!