AnsweredAssumed Answered

Split Attribute field

Question asked by jibbh on Oct 9, 2014
Latest reply on Oct 16, 2014 by curtvprice

I have an Attribute table with several attributes

One of the attributes has the fields

K1-10-11

K1-10-46

K1-10-46c

K1-10-67d (street)

 

I Need all of the elements from the field as seperate attributes

eg an Attribute with

K1

K1
K1

 

another with

10

10

10

 

and a last one with

11

46

46c

67d (without text)

 

I cannot do this manually. Is there a way to do this in ArcGIS 10.1 ?

 

Furthermore I am wondering if it is possible to connect attribute tables with Excel tables without loading the Excel tables (csv) into ArcGIS?

 

Thanks!

Outcomes