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

    Calculation to strip numbers from a field

    ijontichy

      Title

      Calculation to strip numbers from a field

      Post

      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.