Focal Point
[CLOSED] Use of 'matches' function

This topic can be found at:

March 20, 2018, 04:20 PM
[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:

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


Thank you-

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

Windows, All Outputs
March 21, 2018, 05:46 AM
Martin vK
Take a look at the REGEX function.

REGEX documentation

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