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

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.

 

 

Outcomes