Knowledge Base - Technical Articles
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
- Start ArcMap
- Add a dataset or stand alone table to ArcMap.
- Right-click the layer or table in the Table of Contents.
- Select the 'Open Attribute Table' or 'Open' option, depending on the data source.
- 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.
- Define the new field in the 'Add Field' dialog box and click OK.
- Right-click the field name of the new field.
- Select 'Field Calculator.'
- Click 'Yes' to the following prompt:
- 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.'
- Click OK.
Created: 5/30/2002
Last Modified: 5/19/2011
Article Rating:
(2)
(2)
Comments
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:
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:
