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)),
-KurtThis message has been edited. Last edited by: FP Mod Chuck,
Windows, All Outputs
Take a look at the REGEX function.
WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
|Powered by Social Strata|