Focal Point
[SOLVED] Filtering on pattern type?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5867041086

January 06, 2016, 06:37 PM
Max Nevill
[SOLVED] Filtering on pattern type?
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,


WebFocus 8.104
Windows 7 Entreprise, SP1
January 06, 2016, 06:45 PM
Waz
Is this a text field ?

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

Generating a Pattern From a String


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

January 06, 2016, 07:03 PM
Max Nevill
Waz that pattern function is perfect and just what I needed, thank-you!


WebFocus 8.104
Windows 7 Entreprise, SP1