Splunk Search

How can I extract data with delimiter?

yk010123
Path Finder

I have a log entry with the current format: 

 

field=A_B

 

(delimited by underscore)

How can I extract this data into two different fields so that I can create a table 

field1field2
AB
Labels (2)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

If your field is called 'field' then this

| rex field=field "(?<field1>[^_]*)_(?<field2>.*)"

will create new fields 'field1' and 'field2' 

View solution in original post

bowesmana
SplunkTrust
SplunkTrust

If your field is called 'field' then this

| rex field=field "(?<field1>[^_]*)_(?<field2>.*)"

will create new fields 'field1' and 'field2' 

Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...