Splunk Search

REGEX - Replace numbers with an asterisk, multiple apperances

KMoryson
Explorer

Hi, I am trying to find a way to replace numbers in strings with an asterisk, if they are concatenated with one, and if not then also with one, using rex field, example:

AA-1234-12-A
BB-1-132-B-1
56-CC-1-345

to be replaced with:

AA-*-*-A
BB-*-*-B-*
*-CC-*-*

I tried multiple sed commands from the internet but they either don't work properly in splunk or do not solve my issue in the exact.

Many thanks

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Does something like this work for you?

| rex mode=sed "s/\d+/*/g"

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Does something like this work for you?

| rex mode=sed "s/\d+/*/g"
Get Updates on the Splunk Community!

CX Day is Coming!

Customer Experience (CX) Day is on October 7th!! We're so excited to bring back another day full of wonderful ...

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...