Customer Forums

Can I concatenate fields in the import?

Anonymous

Posted: 02 February 2011 06:04 PM Report

My CSV has address details in several columns.  Address line 1, 2, 3 and 4.  It also has city and county.

Can I concatenate the address lines into a single address?

mazza25

Posted: 03 February 2011 11:14 AM Report

 So far I've been achieving this in the file before uploading by using concatenate(a1," ",b1," ") etc. You could replace the space in the "" with a comma though, then pasting the result, as I've not yet found a way to do this in Workbooks

Support

Posted: 03 February 2011 12:11 PM Report

Yes...

Here's some background information.  An example follows:

 

Separate Columns within a CSV import file can be concatenated into a single field in Workbooks.  e.g. first name and last name can be concatenated to populate the name field.  Separate address lines can also be concatenated, and you can choose the separator - a separator is the character that separates the values - it could be a comma, a space, new line / carriage return, or a custom character like a semicolon.

 

Example:

 

Start with a CSV file with well named column headers:

 

Click Start > Import > People > Select the CSV file > Click Next > Click Next again.

The Name fields have been automatically mapped

 

You'll need to manually map the street address fields and specify the concatenation settings.

Scroll down on the right hand side > select Street Address > set the Mapping Type to Concatenate Fields from Source File

 

Select a suitable Concatenated Field Separator

 

Add the address fields that are to be concatenated

 

Also map address town to Person: Town or City > Click Next > Click Run

 

Select the Imported Records tab and click Joe Bloggs' name to open his record.

The name and address fields have been nicely concatenated