REGEX - Replace numbers with an asterisk, multiple apperances

KMoryson — Wed, 01 Jun 2022 09:28:36 GMT

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

Re: REGEX - Replace numbers with an asterisk, multiple apperances

ITWhisperer — Wed, 01 Jun 2022 10:01:21 GMT

Does something like this work for you?

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

topic REGEX - Replace numbers with an asterisk, multiple apperances in Splunk Search

REGEX - Replace numbers with an asterisk, multiple apperances

Re: REGEX - Replace numbers with an asterisk, multiple apperances