5 Replies Latest reply on Sep 10, 2009 2:44 AM by raybaudi

    Calculation to strip numbers from a field



      Calculation to strip numbers from a field


      I am keeping track of a lot of data formatted as follows:   A001   B002   C001     XB002   XC300.


      (It's rolls of film with the letters representing which camera exposed them.   The X indicates 2nd unit photography).


      IS there an easy calc or function that would eliminate the numbers and just give me the camera signifiers--e.g.   Just the LETTERS from the field?


      I suppose I could set up a substitute that knocks out every ordinal, but that seems a bit messy unless there's a way to say "Every ordinal."


      Cheers and thanks in advance.