Splunk Search

How to split a string into multiple fields for different domains

New Member

We have a scenario where we have many domains and we want to split it accordingly . Any advice would be great help .

testcorp1osb_tid
-> product: osb
-> environment: tid
-> region: test
-> segment: corp

procosbtid
-> product: osb
-> environment: tid
-> region: us
-> segment: proc

cvsbpeltid
-> product: bpel
-> environment: tid
-> region: us
-> segment: cvs

Tags (2)
0 Karma

SplunkTrust
SplunkTrust

Are you looking for a rex call? Your question isn't really clear on that.

... | rex field=domain "^(?:(?<region>[^_]+)_)?(?<segment>[^_]+)_(?<product>[^_]+)_(?<environment>[^_]+)$" | eval region = coalesce(region, "us") | ...

New Member

I am able to extract these fields using lookup.

0 Karma

SplunkTrust
SplunkTrust

Regex are the way to go for extracting parts of a string.

Lookups add fields to an event based on some matching fields, similar to an SQL join.

0 Karma

New Member

Do we have any other solution apart from regex? like lookups. I need to pull the values from log and split the string.

EX:

<Jul 25, 2014 9:51:25 AM MYT> <Error> <WliSbCustomResources> <aussoaditapp12.us.dell.com> <apj_corp1_osb_dit_ms2>
0 Karma