Validate Australian Phone Number 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, it answers most of the questions:
- Validate the data
Is Australian Phone Number validation function properties
| Description: |
Validation of Australian phone number. Accepts all forms of Australian phone numbers in different formats (area code in brackets, no area code, spaces between 2-3 and 6-7th digits, +61 international dialling code). Checks that area codes are valid (when entered). |
| Regular Expression: |
^\({0,1}((0|\+61)(2|4|3|7|8)){0,1}\){0,1}(\ |-){0,1}[0-9]{2}(\ |-){0,1}[0-9]{2}(\ |-){0,1}[0-9]{1}(\ |-){0,1}[0-9]{3}$ |
| Pass: |
0403111111|||(03) 1111 1111|||+61403111111|||02 9111 1111|||0403 111 111|||91111111 |
| Fail: |
9111 11111|||99 1111 1111 |
Advanced ETL Processor is designed to automate extracting data from
ANY database,transform, validate it and load into
ANY database. Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle database,run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP,
DTS or SSIS,
Advanced ETL Processor can also add new and update old records based on primary key
