Splunk Search

Can someone help with regex to extract new field?

pacifiquen
Explorer

Hello Team,

can anyone help me with the extraction of new field

 

input: site: mclaudelinemugasqiln.platinilemu.com:1227

 site is a field

domain is mclaudelinemugasqiln.platinilemu.com:1227

i want this output: mclaudelinemugasqiln.platinilemu.com:1227

 

Thank you

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

bowesmana
SplunkTrust
SplunkTrust

Here's an example - is this what you are after with the rex statement?

| makeresults
| eval site="site: mclaudelinemugasqiln.platinilemu.com:1227"
| rex field=site "site:\s?(?<domain>.*)"

This assumes that the site field contains that entire string, i.e. "site: xxx" where xxx is the domain you want to extract.

This creates a new field called domain.

View solution in original post

VatsalJagani
SplunkTrust
SplunkTrust

@pacifiquen - Use the below command within your search:

| rex field=input "site:\s*(?<domain>^\s+)"

 

I hope this helps!!! 

0 Karma

woodcock
Esteemed Legend

... | rename site AS domain | table domain

0 Karma

bowesmana
SplunkTrust
SplunkTrust

Here's an example - is this what you are after with the rex statement?

| makeresults
| eval site="site: mclaudelinemugasqiln.platinilemu.com:1227"
| rex field=site "site:\s?(?<domain>.*)"

This assumes that the site field contains that entire string, i.e. "site: xxx" where xxx is the domain you want to extract.

This creates a new field called domain.

Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...