Splunk Search

Writing reqular expressions

Deepz2612
Explorer

Please help me in writing the regular expression for the below:

2017-11-17 14:20:03 DueDate="11/17/2017", Identifier="12244", ID Year="1887", ID name="Tool-Based", Pickup Contact Phone#="(123) 123-1234"

I wanted to write regular expressions for all the values that are within the Quotes.

Thanks in advance!

Tags (1)
0 Karma

niketn
Legend

These should ideally be extracted automatically during Search Time Field Discovery with KV_MODE=auto. Please validate props.conf for your sourcetype and test out with Verbose Search whether fields get automatically created or not.
Refer to documentation: https://docs.splunk.com/Documentation/Splunk/latest/Admin/Propsconf

If you really want to do it during search time, you can try either KV command or extract command (with kvdelim="=" and pairdelim=","). Following is the run anywhere search based on sample data:
With extract command:

|  makeresults
|  eval _raw="2017-11-17 14:20:03 DueDate=\"11/17/2017\", Identifier=\"2G1WT57K691118585\", ID Year=\"2009\", ID name=\"Tool-Based\", Pickup Contact Phone#=\"(877) 273-5572\""
|  extract kvdelim="=" pairdelim=","

OR with KV

|  makeresults
|  eval _raw="2017-11-17 14:20:03 DueDate=\"11/17/2017\", Identifier=\"2G1WT57K691118585\", ID Year=\"2009\", ID name=\"Tool-Based\", Pickup Contact Phone#=\"(877) 273-5572\""
|  KV

Refer to documentation: https://docs.splunk.com/Documentation/Splunk/latest/Search/Extractfieldswithsearchcommands

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

niketn
Legend

@Deepz2612, can you please confirm whether the solution worked for you or not?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Tiling

This puzzle (first published here) is based on finding groups of tessellated tiles (inspired by floor tiles I ...

SOK it to Me: Top 3 Benefits of Using Splunk Operator on Kubernetes that’ll Make ...

    Thursday, July 9, 2026  |  11:00AM–12:00PM PDT Duration: 1 hour (includes Q&A) Managing can feel like a ...

Upgrade Prep for 10.4, Network Observability Deep Dives, and More from Splunk Lantern

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