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!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...