Check Email address format 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 Email validation function properties
| Description: |
Email Address validation That allows both IP addresses and regular domains. In the case of an IP address it makes sure that it is no more than 255 for each part. |
| Regular Expression: |
^([a-zA-Z0-9_\-\.])+@(([0-2]?[0-5]?[0-5]\.[0-2]?[0-5]?[0-5]\.[0-2]?[0-5]?[0-5]\.[0-2]?[0-5]?[0-5])|((([a-zA-Z0-9\-])+\.)+([a-zA-Z\-])+))$ |
| Pass: |
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
|||
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
|||
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
|
| Fail: |
john@doe|||
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
|||@john.doe.com |
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
