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!

Detecting Brute Force Account Takeover Fraud with Splunk

This article is the second in a three-part series exploring advanced fraud detection techniques using Splunk. ...

Buttercup Games: Further Dashboarding Techniques (Part 9)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Buttercup Games: Further Dashboarding Techniques (Part 8)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...