Exporting Parts of a Field
I have a field that runs in the format of such:
So basically there is always a code before a 5 digit number. Sometimes a .01 or .02 occurs after the number. What I am trying to do is only have the 5 digit number export into excel.
Would anyone know the best solution for this?