Knowledge Base - Technical Articles


Technical Article   HowTo:  Use ArcMap to concatenate fields in a table

Article ID: 22606
Software:  ArcGIS - ArcEditor 8.3, 8.1, 8.1.2, 8.2, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcInfo 8.2, 9.0, 8.1, 8.1.2, 8.3, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcView 8.3, 8.1, 8.1.2, 8.2, 9.0, 9.1, 9.2, 9.3, 9.3.1
Platforms:  Windows 98, NT 4.0, 2000, ME, XP

Summary

Instructions provided describe the necessary steps to concatenate values from two or more fields in a table using ArcMap.

Procedure

  1. Start ArcMap
  2. Add a dataset or stand alone table to ArcMap.
  3. Right-click the layer or table in the Table of Contents.
  4. Select the 'Open Attribute Table' or 'Open' option, depending on the data source.
  5. Select 'Options > Add Field.'

     It is possible to use an existing field, but the output of this process will overwrite existing data in that field.

  6. Define the new field in the 'Add Field' dialog box and click OK.
  7. Right-click the field name of the new field.
  8. Select 'Field Calculator.'
  9. Click 'Yes' to the following prompt:



    [O-Image] Calculate values
  10. Type the following expression, where [Field Name] is the name of each individual field to be concatenated:

    [Field Name] & " " & [Field Name] & " " & [Field Name]



     This expression adds a space between the values that are being concatenated. For further information on the use of the concatenation operator, see the Microsoft Visual Basic Editor Help files. In ArcMap, select Tools > Macros > Visual Basic Editor. In the Visual Basic Editor, click Help > Microsoft Visual Basic Help. Click the Index tab, type "concatenation operators", and click 'display.' Select '& operator' and click 'display.'

  11. Click OK.

Created: 5/30/2002
Last Modified: 5/19/2011

Article Rating: (2)
If you would like to post a comment, please login

Comments

By lamalfred - 05/18/2011 9:15 PM

The article needs to be updated.

good, you can repeat the codes on the same field.

Rating:

By Anonymous - 10/27/2009 10:13 AM

The article has missing, misleading, or conflicting information.

In step #8, shouldn't it read "Field Calculator"?

Rating: