Calculation that removes spaces in field

[Mark Appleby]

I am having trouble. Can anyone help me?

Simply, I need to take a field that is my supplier style referance and re calcualte it without any spaces or non alpha numeric characters. I mean remove verything that is not from a...Z and 1...0. An example would be changing (a4.32 1 /3) to (A43213) Can I do this some way?

I look faorward to your help.

[kenneth2k1]

Well, how about a calc field that evaluates the Reference # field and substitutes out those characters?

You will need two fields, I will call them RefNo and RefNoCalc

RefNo is a text field that contains the reference number from the supplier.

RefNoCalc will be a calc field:

Substitute(Substitute(Substitute(RefNo, "/" , ""), "." , ""), "-", "")

Do not store calc. You can nest more substitutions if there are more symbols. You can sub out spaces in the same manner, using " " , ""

Have fun

Ken

[Mark Appleby]

Kenneth,

Thanks for the help, you have saved me many hours of keyboard plugging and tought me about the substitute function, which I never used before! We learn something new every day.