Focal Point
[CLOSED] Use of 'matches' function

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

March 20, 2018, 04:20 PM
KurtR
[CLOSED] Use of 'matches' function
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
March 21, 2018, 05:46 AM
Martin vK
Take a look at the REGEX function.

REGEX documentation


WebFocus 7.7.06M/8.2.03M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster