Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Filtering on pattern type?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Filtering on pattern type?
 Login/Join
 
Gold member
posted
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
 
Posts: 82 | Location: Abbotsford BC | Registered: March 15, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6105 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Waz that pattern function is perfect and just what I needed, thank-you!


WebFocus 8.104
Windows 7 Entreprise, SP1
 
Posts: 82 | Location: Abbotsford BC | Registered: March 15, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Filtering on pattern type?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.