How to use extract using rex command? - Splunk Community

Splunk Search

"Context":"{"user id":"jane.doe.sen", "Expense Date":"11/10/2022",

How to use extract this rex command?

to come up result like

user id	Expense Date
jane.doe.sen	9/6/2022

please help

Assuming the field is as written and is in the _raw field

| rex "user id\":\"(?<user_id>[^\"]*)\",\s+\"Expense Date\":\"(?<expense_date>[^\"]*)"

Get Updates on the Splunk Community!

New Year. New Skills. New Course Releases from Splunk Education

A new year often inspires reflection—and reinvention. Whether your goals include strengthening your security ...

Splunk and TLS: It doesn't have to be too hard

Overview Creating a TLS cert for Splunk usage is pretty much standard openssl. To make life better, use an ...

Faster Insights with AI, Streamlined Cloud-Native Operations, and More New Lantern ...

Splunk Lantern is a Splunk customer success center that provides practical guidance from Splunk experts on key ...