Is US or CA Zip code

Validate US or Canadian ZIP code in three simple steps

Download and install the software, here are the links to the latest version

Advanced ETL Processor:

Watch the following on-line tutorial to understand data validation process:

Performing Data validation and transformation

In this tutorial, you will learn basic steps of validating text file using Advanced ETL Processor
Validate the data

Is US or CA Zip code validation function properties

Name	Value
Description:	Validates US or CA Zip code format
Regular Expression:	^((\d{5}-\d{4})\|(\d{5})\|([AaBbCcEeGgHhJjKkLlMmNnPpRrSsTtVvXxYy]\d[A-Za-z]\s?\d[A-Za-z]\d))$
Pass:	00501\|\|\|84118-3423\|\|\|n3a 3B7
Fail:	501-342\|\|\|123324\|\|\|Q4B 5C5

Advanced ETL Processor has a robust data transformation process built in.

The types and nature of the transformations taking place can be tweaked and configured by the user. A full range of data transformation functions is included. Transformations can be performed on the basis of data type, lookups and regular expressions, which can be individually changed according to the requirements.

Additional Information:

↑