I have a somewhat related question, though it pertains to Arcmap 9.3.1.
I have a field [Col_Row] that gives the column and row of a shapefile grid in the format of 23-999.
I want to extract the columns and rows into their own fields such that "23-999" becomes "23" and "999" using "-" as a delimiter. The problem is that the lengths are variable, eg the field can contain values like "1-2", "351-7", "81-253" which makes substring, trim, left and right commands tricky.
I've tried using substring as follows:
substring([Col_Row],1,instr([Col_Row],'-')-1)
But I get a VBA error...
Any help would be much appreciated. Such a simple task, and yet I've already spent hours trying to do it.