Splunk Search

regex to replace numeric value as astreik

DataOrg
Builder

i want search search level field extraction command to replace all numeric value as astriek

Name = Dell vostro 2012 laptop wireless
Name = HP latitude laptop 20161 home station
Name is the field followd by value

I want results as
Name = Dell vostro **** laptop wireless
Name = HP latitude laptop **** home station

0 Karma
1 Solution

jpolvino
Builder

If you want to get rid of numbers, you can use sed to replace them with nothing (also removes leading space):

(your search)
| rex field=Name mode=sed "s/\s\d+//g" 

You said replace with asterisk, I believe, which would be:

(your search)
| rex field=Name mode=sed "s/\s\d+/\*/g"

View solution in original post

jpolvino
Builder

If you want to get rid of numbers, you can use sed to replace them with nothing (also removes leading space):

(your search)
| rex field=Name mode=sed "s/\s\d+//g" 

You said replace with asterisk, I believe, which would be:

(your search)
| rex field=Name mode=sed "s/\s\d+/\*/g"
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...