topic Re: Issue using rex to replace string in Splunk Search

Issue using rex to replace string

Scharf — Thu, 21 Mar 2024 18:29:49 GMT

Hello world,

I'm trying to use rex to rename the part of the strings below where it says "g0" to "GRN". So the output would read 01-GRN1-0, 01-GRN2-0etc. I have been unable to get it to work and any guidance to point me in the right direction would be much appreciated.
The rex statement in question:

| rex field=ThisField mode=sed "s/g0/\GRN/g"

Example strings:

01-g01-0

01-g02-0

01-g03-0

Re: Issue using rex to replace string

isoutamo — Thu, 21 Mar 2024 18:35:51 GMT

you should remove \ before G.

r. Ismo

Re: Issue using rex to replace string

ITWhisperer — Thu, 21 Mar 2024 18:39:09 GMT

You don't need the backslash - here is a runanywhere example showing it working

Re: Issue using rex to replace string

Scharf — Thu, 21 Mar 2024 18:42:13 GMT

Yeah I tried that first, but other related issues on the boards led me to try it with the backslash. It returns the same results.

Re: Issue using rex to replace string

ITWhisperer — Thu, 21 Mar 2024 18:49:10 GMT

The search works as shown which probably means there is something different in your environment which hasn't been made clear to us. Please can you provide more details and examples of where this substitution is not working as expected?

Re: Issue using rex to replace string

Scharf — Thu, 21 Mar 2024 19:11:44 GMT

It turns out the cause of my issue was another rex statement down the line that hadn't been updated to match the renamed string. It used

(?<Foo>\D\d*)-0

which matched the string before the replacement, which the statement is now

(?<Foo>\D*\d)-0

Apologies for my confusion. I've marked your efforts as the solution as the backslash was indeed not needed.

Thank you and have some Karma for your efforts.