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
Get Updates on the Splunk Community!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...