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    [CLOSED] Use of 'matches' function
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Use of 'matches' function
 Login/Join
 
Member
posted
I am attempted to set a variable via an Alter Format where a data column matches specific format (in this particular case, a 9 digit zip code where the first 5 characters are digits, then a hyphen, then four digits).

I am not getting the match I expect using this code, please advise:

CASE (
( Length( the_column ) = 10 ) AND ( matches( '\d\d\d\d-\d\d\d\d\d', the_column)),
'is_9digit_USzipcode',

'is_not_9digit_USzipcode'
)

Thank you-
-Kurt

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 3 | Registered: September 25, 2016Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Take a look at the REGEX function.

REGEX documentation


WebFocus 7.6.9/7.7.06M, iWay DataMigrator, ISM, Windows, DB2 Windows V10.5, MS SQL Server, Hyperstage
 
Posts: 141 | Registered: March 29, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Use of 'matches' function

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