Placeholder

Customer Forum

Can I concatenate fields in the import?

Workbooks Support Posted: 2011-02-02 18:04

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?

External Posted: Thu, 03.02.2011 - 11:14

 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.

Workbooks Support Posted: Thu, 03.02.2011 - 12:11

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:

Image removed.

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

The Name fields have been automatically mapped.

Image removed.

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'.

Image removed.

Select a suitable Concatenated Field Separator.

Image removed.

Add the address fields that are to be concatenated.

Image removed.

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

Image removed.

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

The name and address fields have been nicely concatenated

Image removed.