Splunk Search

Adding delimiter to a field values

Laxman24
Explorer

Hi all,

I need some help in creating a new field,

I have a field like following

Field 1
AABBCCDDEEFF
AAAABBBBCCCC

 

Id like to make a new field and the values become :

AA-BB-CC-DD-EE-FF
AA-AA-BB-BB-CC-CC

 

could someone help me with this?

Thanks in advance!

Labels (1)
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| rex mode=sed "s/(?<pair>\w{2})/\1-/g s/-$//g"

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| rex mode=sed "s/(?<pair>\w{2})/\1-/g s/-$//g"

ayushisrivastav
Engager

Hi @ITWhisperer , 

please can you explain me the regular expression which you have written to fulfil the request.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Firstly, rex is put into stream-edit (sed) mode.

The regular expression is in two parts (separated by a space)

Secondly, the first sed expression means substitute (s) the captured group (?<pair>\w{2}) of 2 word-characters with the first captured group (\1) followed by a hyphen (1) done globally (g) through the field.

Thirdly, the second sed expression means substitute (s) the hyphen (-) at the end ($) for nothing i.e. remove it.

Laxman24
Explorer

Thank you!!!! 🙂 it works

0 Karma
Get Updates on the Splunk Community!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...