Getting Data In

Regex Help

SS1
Path Finder

Hi,

I have the below log entry, can you help with the regex to extract the line in Red. The regex i have is not working properly in props.conf

 

2021-09-23 19:03:40.802 INFO 1 --- [sdgfsdgsdfgsdfg] asdfasdfasdfasfasfgfdhdfhdf : Response --> {
"claimId" : asfdasdfadf,
"claimFilerId" : "sadfasdf",
"vendorName" : "asfasfadfadf. ",
"vendorId" : "aefadf",
"vendorAddressId" : "asfafsd",
"vendorAddress" : "sdfgsdgsfg",
"preparedDate" : "09-22-2021",
"receivedDate" : "09-22-2021",
"enteredDate" : "09-22-2021",
"assignedTo" : {
"employeeId" : "sdfasdf ",
"firstName" : "asfasf",
"lastName" : "zsdfdf",
"adUserIdentifier" : "zsdfvzdv"
},
"correspondence" : {
"type" : {
"code" : 5947,
"shortName" : "EOB",
"longName" : "EOB"
},
"dispatchCode" : {
"code" : 5947,
"shortName" : "NtRqd",
"longName" : "Not Required"
},
"emailAddress" : "abcd@g.com,       dgfh@a.in"
}

0 Karma

SS1
Path Finder

you mean transforms.conf ?

Below are the two regex's i tried

[email-anonymizer]
REGEX = (^.*[^.]+)(^.*[^.]+)(?ms)(\"emailAddress\")(.*)
FORMAT = $1$2$3########
DEST_KEY = _raw

[ss-email-anonymizer]
REGEX = (^.*[^.]+)("[A-z0-9._%+-]+@[A-z0-9.-]+\.[A-z]{2,63}),\s*([A-z0-9._%+-]+@[A-z0-9.-]+\.[A-z]{2,63}")(\s.*[^.]+)
FORMAT = $1###########$4
DEST_KEY = _raw

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

What regex do you have in props.conf?

0 Karma
Get Updates on the Splunk Community!

Unlock Database Monitoring with Splunk Observability Cloud

  In today’s fast-paced digital landscape, even minor database slowdowns can disrupt user experiences and ...

Purpose in Action: How Splunk Is Helping Power an Inclusive Future for All

At Cisco, purpose isn’t a tagline—it’s a commitment. Cisco’s FY25 Purpose Report outlines how the company is ...

[Upcoming Webinar] Demo Day: Transforming IT Operations with Splunk

Join us for a live Demo Day at the Cisco Store on January 21st 10:00am - 11:00am PST In the fast-paced world ...