Splunk Search

How to remove words and characters from a multivalued filed

MeMilo09
Path Finder

Hello All, 

How can I remove words and characters from a multivalued field without using REX?

I have a filed named OS

OS:
Windows-2016
Windows-2010


How can I take out everything that comes in before the hyphen and just end up with the below?

OS:
2016
2010


Labels (2)
Tags (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Try mvmap and replace.

| makeresults 
| eval OS="Windows-2016
Windows-2010" 
| eval OS=mvmap(OS,replace(OS,"Windows-",""))

 

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

ITWhisperer
SplunkTrust
SplunkTrust

@richgalloway Your example doesn't create a mv-field but your solution works when the field is mv.

| makeresults 
| eval OS=split("Windows-2016
Windows-2010" ,"
")
| eval OS=mvmap(OS,replace(OS,"Windows-",""))

 

MeMilo09
Path Finder

Pretty close, just used mvindex instead. Thanks 

| eval OS_Name=split(OSName,"-"), Env=mvindex(OS_Name, 1)

0 Karma
Get Updates on the Splunk Community!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...