Splunk Search

Can anyone provide me a simple example for using REGEX with DELIMS?

zcwang
New Member

Could anyone provide me a simple example for using REGEX with DELIMS? The event in my scenario is full of delimiter-separated field/value pairs, so I used two sets of quoted delimiters. However, the first set of delimiters might be either "," or " ". So I wonder if I could use an OR for the first delimiter. Thanks!

Tags (2)
0 Karma

Richfez
SplunkTrust
SplunkTrust

zcwang,

An example of the item in question would make this easier, but I'll try:

Any of the delimiter characters you specify will be considered a delimiter. The docs for transforms.conf provides an example of this

[multiple_delims]
DELIMS = "|;", "=:"

Which they describe as The above example extracts key-value pairs which are separated by '|' or ';', while the key is delimited from value by '=' or ':'.

So that would use either | or ; for the field separators and either one of = or : as the field=value separator. This would match log lines like

|field1=val1;field2=val2|field3:val3;field4=val4;

and pull out of them

field1=val1
field2=val2
field3=val3
field4=val4
0 Karma

MuS
SplunkTrust
SplunkTrust

providing some sample events will be useful in this case.....

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...