Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- What is the regular expression for my use case?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i am unable to display dv_state="Closed Complete" from the data. please help me with REX for this use case.
dv_state="Closed Complete"
dv_state="Open"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I answered similar question that would have extracted all the "dv_" for you from your data but seems you had figured it out there:
https://answers.splunk.com/answers/475190/help-me-rex-extraction.html#answer-474189
However just for this state piece this is how u do it :
yourQuery to return the data
| rex "dv_state\=\"(?<state>[^\"]+)"
| table state
If you also want the dv_state= in the string as wel use this:
yourQuery to return the data
| rex "(?<stateField>dv_state\=)\"(?<state>[^\"]+)"
| eval myString=stateField."\"".state."\""
| table stateField, state, myString
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rex "dv_state=\"(?<dv_state>[^\"]*)\""
Regular Expressions is a Language for it's own... there are many good creators for that.
online I often use regexr(dot)com
On Mac is regExRX a good choice
Kind regards
Darth
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I answered similar question that would have extracted all the "dv_" for you from your data but seems you had figured it out there:
https://answers.splunk.com/answers/475190/help-me-rex-extraction.html#answer-474189
However just for this state piece this is how u do it :
yourQuery to return the data
| rex "dv_state\=\"(?<state>[^\"]+)"
| table state
If you also want the dv_state= in the string as wel use this:
yourQuery to return the data
| rex "(?<stateField>dv_state\=)\"(?<state>[^\"]+)"
| eval myString=stateField."\"".state."\""
| table stateField, state, myString
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Index This | What travels the world but is also stuck in place?
Discover New Use Cases: Unlock Greater Value from Your Existing Splunk Data
Continue Your Journey: Join Session 2 of the Data Management and Federation Bootcamp ...
