All Apps and Add-ons

How to split one field into two using regex?

Italy1358
Path Finder

Hello, I am working on a Splunk query and I need help adjusting my rex command to get two fields that are in one field into their own fields. Example below:
index=test sourcetype=test category=test
| rex field=user "(?<region>[^\/]+)\/(?<username>[^\w].+)"
| fillnull t
| sort _time
| table _time, username, user, region, sourcetype,  result, t
| bin span=1d _time
| dedup t

The user field has: test\test1 and I need it to split that so username=test region=test1

Labels (1)
Tags (3)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @Italy1358,

if the format of your user field is "test\test1", your regex is wrong, please try this:

| rex field=user "^(?<region>[^\\]+)\\(?<username>.+)"

that you can test at https://regex101.com/r/eLZV41/1

Ciao.

Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @Italy1358,

if the format of your user field is "test\test1", your regex is wrong, please try this:

| rex field=user "^(?<region>[^\\]+)\\(?<username>.+)"

that you can test at https://regex101.com/r/eLZV41/1

Ciao.

Giuseppe

Get Updates on the Splunk Community!

ATTENTION!! We’re MOVING (not really)

Hey, all! In an effort to keep this Slack workspace secure and also to make our new members' experience easy, ...

Splunk Admins: Build a Smarter Stack with These Must-See .conf25 Sessions

  Whether you're running a complex Splunk deployment or just getting your bearings as a new admin, .conf25 ...

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...