topic Re: How split up a string into multiple fields in Splunk Search

How to split up a string into multiple fields?

HeinzWaescher — Mon, 11 Jan 2021 19:34:39 GMT

Hi,

let's say there is a field like this:

FieldA = product.country.price

Is it possible to extract this value into 3 different fields?

FieldB=product
FieldC=country
FieldD=price

Thanks in advance

Heinz

Re: How split up a string into multiple fields

lpolo — Fri, 16 May 2014 13:30:27 GMT

Try this:

your query |rex "FieldA\=(?<FieldB>.*)\.(?<FieldC>.*)\.(?<FieldD>.*)"|table FieldA FieldB FieldC FieldD

Re: How split up a string into multiple fields

somesoni2 — Fri, 16 May 2014 13:33:33 GMT

Following could be the option your can use:(assuming delimiter is dot "." between field values)

REX command

 your base search | rex field=FieldA "(?<FieldB>.*)\.(?<FieldC>.*)\.(?<FieldD>.*)"

Split command

your base search | eval temp=split(FieldA,".") | eval FieldB=mvindex(temp,0)| eval FieldC=mvindex(temp,1)| eval FieldD=mvindex(temp,2) | fields - temp

Re: How split up a string into multiple fields

richgalloway — Fri, 16 May 2014 13:34:02 GMT

Here's one way to do it at search time:

... | rex field=FieldA "(?<FieldB>[^\.]*)\.(?<FieldC>[^\.]*)\.(?<FieldD>[\S]*)"

Re: How split up a string into multiple fields

pavan_bhumanapa — Mon, 28 Sep 2020 17:14:51 GMT

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

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

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

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

Re: How split up a string into multiple fields

HeinzWaescher — Mon, 04 Aug 2014 07:41:53 GMT

Do you have a "region" in your string in the examples 2 & 3?

Re: How split up a string into multiple fields

sundarrajan — Fri, 31 Mar 2017 12:41:39 GMT

In line to the same above scenario, what if the values in the fields are not even? like FieldA has the following values,
product.country
product
product.country.price
product.price
product.country.price
in the above scenario, i tried split, but it is not working (but works). how to quantify for missing values/null values? i couldn't quantify for null values in the fields.

Re: How split up a string into multiple fields

robertlynch2020 — Wed, 08 Nov 2017 16:07:56 GMT

Did you get an answer to this?

Re: How split up a string into multiple fields

aebrittingham — Thu, 09 May 2019 21:08:30 GMT

I know, 5 years later but I need this to separate multiple fields delim by :
This working swimmingly for what I needed

Re: How split up a string into multiple fields

Thats_my_usrnme — Thu, 10 Nov 2022 14:28:14 GMT

Hello its so usefull. Thanks for the query . I have a question for this subject. I have a FieldA and this fileds like a FieldA="a\b\c\n\....\z" . its a long field. I want it to automatically split the field and give each value a name. so I actually want to see a manual version of field transforms. If you have an idea and would like to help, I would be glad.