Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides > Is E-mail Valid Function
  APATAR FUNCTION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Is E-mail Valid Function
Added by Alexander Pipko, last edited by Alex Khizhnyak on Jun 28, 2008  (view change)
Labels: 
(None)

This guide will help you learn how to filter out the strings that are entered in invalid e-mail address formats. The Is E-mail Valid function is based on the validation with Regular Expressions only, no real e-mails are sent to the addressee.

Configuration

To start validating e-mail address formats,

  1. Configure data sources and provide the mapping



    In this example, we will use the following table as a source:



  2. Open the Filter (or Validate) node
  3. Click on the String section to find the Is E-mail Valid icon
  4. Drag-and-drop it to the Filtration's work panel



  5. As well, drag-and-drop the field that contain values for validation
  6. Map the nodes according to the picture below



  7. Press Ok and close the Filtration window

Now the output table will contain only those records where the Column field value is entered in an e-mail address format.

Preview

To preview the results, right-click on the output node and select "Preview Results". The following window will pop up:

           

Close the window and continue data integration.

See also

     StrikeIron Email Verification


Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators