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!

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

How to find the worst searches in your Splunk environment and how to fix them

Everyone knows Splunk is a powerful platform for running searches and doing data analytics. Your ...

Share Your Feedback: On Admin Config Service (ACS)!

Help Us Build a Better Admin Config Service Experience (ACS)   We Want Your Feedback on Admin Config Service ...