Splunk Search
Highlighted

Splunk Field Extraction inside a bracket

Builder

Hi All,
Is there any faster way to extract fields with this format on props and transforms file? like Key value pair ?
There's a lot more field than that , that's why im finding an easier way to extract field value

2020/03/01-10:01:01 [firstname "JOHN"] [surename "DOE"] [age "30"] [state "NY"] [id "10001"]
2020/03/01-10:01:02 [firstname "Julie"] [age "58"] [state "AU"] [id "10002"]
2020/03/01-10:01:02 [firstname "MEGAN"][middlename "myra"] [surename "DOE"] [age "58"] [state "AU"] [id "10052"]
0 Karma
Highlighted

Re: Splunk Field Extraction inside a bracket

SplunkTrust
SplunkTrust

Faster than what? Easier than what? What are your current props.conf settings?

---
If this reply helps you, an upvote would be appreciated.
0 Karma
Highlighted

Re: Splunk Field Extraction inside a bracket

Esteemed Legend

Like this:

REGEX = \[(?<key>\S+)\s+"(?<value>[^"]+)
FORMAT = $1::$2

See here:
https://regex101.com/r/ZvxlMY/1

View solution in original post

0 Karma
Highlighted

Re: Splunk Field Extraction inside a bracket

Builder

thanks @woodcock - this is very helpful.
Can i use this command for specific logs only ? i need this configuration for INFO only not DEBUG?
https://regex101.com/r/ZvxlMY/2

 2020/03/01-10:01:01 INFO [firstname "JOHN"] [surename "DOE"] [age "30"] [state "NY"] [id "10001"]
 2020/03/01-10:01:02 DEBUG [firstname "Julie"] [age "58"] [state "AU"] [id "10002"]
 2020/03/01-10:01:02 INFO [firstname "MEGAN"][middlename "myra"] [surename "DOE"] [age "58"] [state "AU"] [id "10052"]
0 Karma
Highlighted

Re: Splunk Field Extraction inside a bracket

Esteemed Legend

There is no sense in limiting the field extraction. Limit it in your search. Create your stanza based on sourcetype.

0 Karma