It scrubbing time :) Need help with parsing

[Drew Sanderson]

The project I am working on involves existing data with a serialized stock number that carries meaning.

There are two varieties:

A1234567

AA123456

The letter(s) refer to the vendor the item came from. I would like to capture just the letters away from numbers.

How can this be accomplished?

Thanks,

Drew

Edited December 21, 2006 by Guest

[Tom Elliott]

How about:

Filter ( StockNumber ; "abcdefghijklmnopqrstuvwxyz" )

[Drew Sanderson]

Thanks for getting back to me so quick. I have entered the calc but not tested it. i will post back soon.

Thanks!

[LaRetta]

Filter() is case-sensitive so you might want to use capitals.

[Drew Sanderson]

Thanks for the tip on the case sensativity. It all works like a charm. Thanks everyone.... now if I can only get a response to my other currently posted problem.

Thanks :o