Splunk Search

How to combine two field values into one field from a .csv file?

cdson
Explorer

Hello! 

I have a csv file where there are two fields called "Customers First Name" and "Customers Last Name".  I was wondering if there is a way to combine the values of each field in the same row into one new field.

 

Thank you! 🙂 

 

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

richgalloway
SplunkTrust
SplunkTrust

There are a few ways to do that.  The simplest is the concatenation operator '.'.

| eval CustomerName = 'Customers First Name' . 'Customers Last Name'
---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

There are a few ways to do that.  The simplest is the concatenation operator '.'.

| eval CustomerName = 'Customers First Name' . 'Customers Last Name'
---
If this reply helps you, Karma would be appreciated.

cdson
Explorer

Thank you very much! Have a good day!

0 Karma
Get Updates on the Splunk Community!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...