AnsweredAssumed Answered

Calculation to strip numbers from a field

Question asked by ijontichy on Sep 9, 2009
Latest reply on Sep 10, 2009 by raybaudi


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.