topic Re: How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12 in 911 GIS Questions

How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12

MikeLetterman — Fri, 08 Jul 2016 21:10:57 GMT

I have a feature in a geodatabase with over a thousand records and need to add dashes to the numbers in a field.

Example: 6411 10 6411 12 to 6411-10 6411-12

Re: How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12

ChrisDonohue__GISP — Fri, 08 Jul 2016 22:14:50 GMT

For starters, you would need a field that is a string type (text) not numerical. You can then populate it by concatenating a dash into it at the appropriate places.

For example, a simplistic way would be to shred 6411 10 6411 12 down to it's 4 pieces and place each piece in it's own field, say field A, B, C, D. For example, A would contain 6411, B 10, etc. Then create a text field for your final result, we'll call it field E. Then run Field Calculator on field E, with the VB script expression: & "-" & & " " & & "-" & .

There are probably even easier/more elegant ways to do this with Python.

One catch will be whether all your data is laid out in the same sequence; if it varies it may take some data cleanup or additional code to get it sorted out before concatenating.

Chris Donohue, GISP

Re: How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12

DanPatterson_Retired — Sun, 12 Dec 2021 10:54:55 GMT

In python it is a bit easier since there is a way to do away with all that stupid converting types from int/float to string and the like. onsider

>>> a = 1
>>> b= 'b'
>>> c=1.2
>>> d ='x'
>>> "{}-{}-{}-{}".format(a,b,c,d)
'1-b-1.2-x'

now your destination field still needs to be a string, but all you need to do is set your parser to python and use your field names enclosed in exclamation marks like

"{}-{}-{}-{}".format( !a!, !b!, !c!, !d! )

Re: How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12

BlakeTerhune — Fri, 08 Jul 2016 23:24:25 GMT

I like the string.format() method because the values your concatenating with the dashes don't have to be strings, it will do the casting automatically. But like Dan mentioned, just make sure the output field is a string with a long enough length to accommodate the new value.

Re: How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12

DanPatterson_Retired — Fri, 08 Jul 2016 23:28:29 GMT

in python 3.6, this is now even more simplified...

if you like raw format r"f:\test\path"

you will love the new format What’s New In Python 3.6 — Python 3.6.0a2 documentation

f formatting

>>> name = "Fred"

>>> f"He said his name is {name}."

'He said his name is Fred.'

Re: How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12

BlakeTerhune — Fri, 08 Jul 2016 23:47:12 GMT

Oooh, shiny.

Re: How do you add dashes using field calculator? Example 6411 10 6411 12 to 6411-10 6411-12

JoshuaBixby — Sat, 09 Jul 2016 14:32:39 GMT

I agree, formatted string literals are nice syntactic sugar. Unfortunately, we still have some time until final release and then a bit longer until incorporated into ArcGIS products.