topic Replace Eval Function using Regex in Splunk Search

Replace Eval Function using Regex

Substance82 — Thu, 27 Jun 2024 21:18:45 GMT

When using regex how can I take a field formatted as "0012-4250" and only show the 1st and lat 3 digits? I tried the following in which maintains the original output:

| eval AcctCode = replace(AcctCode,"(\d{4}-)(\d{4})","\1\2")

Re: Replace Eval Function using Regex

richgalloway — Thu, 27 Jun 2024 20:31:36 GMT

The current regex takes the first 4 digits and the last 4 digits and then puts them back together, which is why the result does not change. Try this, which takes the first and last 3 digits and puts them together.

| rex field=AcctCode mode=sed "s/(\d{3})\d-\d(\d{3})/\1\2/"

Re: Replace Eval Function using Regex

Substance82 — Thu, 27 Jun 2024 20:35:49 GMT

Hi.

Your reply is greatly appreciated, but I must use the eval command to achieve my results. Do you have an eval command solution?

Re: Replace Eval Function using Regex

Substance82 — Thu, 27 Jun 2024 23:51:37 GMT

Nevermind All.

By some miracle I figured it out!

| eval ProdCode = replace(ProdCode,"^(\d)\d{3}-\d(\d{3})","\1xxx-x\2")