Splunk Cloud Platform

concatenate syntax

verifi81
Path Finder

Hi folks

I'm providing a sample of many values I have for field: username

Field: username

Value: 

Roger Smith
Bob Dole
Randy Savage

I'm trying to create another field with the EVAL command called EMAIL and placing a dot between first name and last name followed by @Anonymous.com

Basically I'm trying to get the new field like this.

Field: Email

Roger.Smith@falcon.com
Bob.Dole@falcon.com
Randy.Savage@falcon.com

What would the syntax be?

 

Thanks in advance

Labels (1)
0 Karma
1 Solution

kamlesh_vaghela
SplunkTrust
SplunkTrust

@verifi81 

 

You should try something like this.

YOUR_SEARCH | eval email= replace(username," ",".")."@falcon.com" | table username email

 

Sample search.

 

| makeresults | eval _raw="
username
Roger Smith
Bob Dole
Randy Savage
" | multikv forceheader=1 | eval email= replace(username," ",".")."@falcon.com" | table username email

 

 

 

View solution in original post

0 Karma

verifi81
Path Finder

I stand corrected. It worked. Thank you!

0 Karma

verifi81
Path Finder

Hello Kamlesh,

My list of username is 1000 entries long so I won't be able to specify it like that. 

 

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@verifi81 

 

You should try something like this.

YOUR_SEARCH | eval email= replace(username," ",".")."@falcon.com" | table username email

 

Sample search.

 

| makeresults | eval _raw="
username
Roger Smith
Bob Dole
Randy Savage
" | multikv forceheader=1 | eval email= replace(username," ",".")."@falcon.com" | table username email

 

 

 

0 Karma
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...