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

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?