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

[cdson]

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! 🙂 

[richgalloway · Accepted solution]

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

| eval CustomerName = 'Customers First Name' . 'Customers Last Name'

[cdson]

Thank you very much! Have a good day!