Hi all,

I have an odd thing I'd like to filter on. I have a variable alpha field which has the following patterns:
999
999999
99
99 999
9999
99999
9
99 99
999 99
9999 9
+9
9-999
9 999
+99
(999)
99-99
999-99
.
9 9999
999-
99 9 9
99-999
9999-9
99 9
999 9
9-9
99-
9
+99999
99(9)
9999-
999A99
999a
AA
9 9
9 99
9(999)
9+9
99A
99`
9A9


I want to filter out the 999s so I can pull everything else (which are wrong and someone else has to manually clean). Any quick and easy way to do this?

This message has been edited. Last edited by: Tamra,

Is this a text field ?

There is a function for getting the pattern of a string.

Generating a Pattern From a String

Waz that pattern function is perfect and just what I needed, thank-you!