Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to build a field calculator expression to merge two columns into one. I am looking for the word that makes it a range.

Example: I have 2 columns in elevation, From and To. I want to make them like "4100 - 4200" where I add the hyphen. How do I do that ?

table showing data being worked with

share|improve this question
up vote 13 down vote accepted

You will want to concatenate the two fields together.

To do this in ArcMap you can use the VB Script function "&". So using your example, the calculation would be

[FROM] & "-" & [TO]

You could also use Python syntax, in which case your code would be:

str(!FROM!) + "-" + str(!TO!)

With Python you want to be sure to enclose the fields in the string function -- str()--, so that Python knows you are trying to concatenate two strings together, and not do a mathematical computation.

share|improve this answer
    
just for fun, you could also use the format string python operator: "%s - %s" % (str(!FROM!), str(!TO!)), which in this case is more complicated than the above, but is easier if you want to more extended concatenations, e.g. "Min %s - to - %s Max" % (str(!FROM!), str(!TO!)) – matt wilkie Oct 11 '11 at 22:56

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.