AnsweredAssumed Answered

Extracting numbers from a column

Question asked by geonetadmin on Jun 18, 2013
Latest reply on Jun 20, 2013 by Wayne_Whitley
Original User: powell21

Hey,
I am trying to execute a join of a table to a shapefile.  There is a column (in properties, type is "doube") in the shapefile that contains a long code (11 characters).  I need the middle five numbers to be in their own column in order to have it correspond to the correct column in the table. 

i.e. Field in column = 11705120000 and I need 05120 to be in its own column for it to match up with the table correctly.

Is it possible to extract just those numbers, and if so, how?

Thanks!

Emily

Attachments

Outcomes