arcgis-10.2arcgis-desktoparcmapfield-calculatorpython-parser
I am using ArcMap 10.2.2.
I have three attribute fields (Address_No: 1, StreetName: Main, Street_Ty: ST) that I want to merge together. How do I concatenate string data found within the table plus numeric data?
I would like the following result: 1 attribute field – Address: 1 Main ST
I couldn't find a way to do it on the ArcGIS side of things, but you could easily create a computed column to do this on the database side.
For example, on SqlServer I would perform the following:
alter table TABLENAME add COLUMNNAME as FIELD1 + ' ' + FIELD2 +' ' + FIELD3
Then, any time someone queries the layer and requests COLUMNNAME, they'll get whatever values are currently in FIELD1, FIELD2, and FIELD3, concatenated.
UPDATE: One big caveat, though. I just noticed an ESRI article that asks the question "Can I use Microsoft SQL Server computed column with ArcSDE?" Apparently, if you're on SDE 8.3, 9.0, or 9.1, you can't compress the database if you're using a calculated field. I don't know if this applies to later versions, though.
if !myField! == 'NULL' will not test for a null value. That will test a for a string equal to 'NULL'. Use:
if !myField! is None:
To accomlish your task, define a python function in the pre-logic code block and use that function in the expression window. The following code sample pulls the first token from a '-' delimited string.
Best Answer
No need to write a function here. Just hit the Python radio button, and then write this into the box:
What is important:
- field names are represented by their name but embraced by exclamation points: !
- any numeric field needs to be converted to a string when concatenating with other strings. To do that in Python, use the str() function. Anything within the parentheses will be converted o a string, even if it is a number
- You should add blank characters (" ") between your parts, to format this nicely, so it appears like: Address: 1 Main ST instead of Address:1MainST