Cleaning data

[noelgarry]

Hi
I have a table that contains telephone numbers.
The data is in a variety of formats.
Here are some examples:
087 123456
087-123456
(W)087-123456
(H)123456

I would like to strip out hyphens, brackets, spaces, etc.

I hope to do this in a straighforward make table query.

Is there a function available that will strip out non-numerics characters?

Thanks
Noel

 

[rsmonkey]

SELECT tablename.telephonenumber FROM tablename WHERE ((tablename.telephonenumber ) Like "*-*");

put that badboy into a loop then do an Update statement to replace with watever you you want a space " " or nothing "".

and loop all that...

job done!