Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides > Match RegExp Function
  APATAR FUNCTION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Match RegExp Function
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on May 01, 2008  (view change)
Labels: 
(None)

This guide will help you learn how to configure the Match RegExp function and identify if a string matches a specified Regular Expression.

Description

The Match RegExp function enables users to validate and filter data using specified regular expressions within Apatar. With this function, Apatar users can filter out records that do not match the criteria specified by regular expressions. Users can set the rules or a template for string formats, such as e-mail addresses, phone numbers and area codes, or IP addresses, to match. Implemented within the Filter or Validate operations, this feature may be useful in determining the validity of any formatted data and ridding database of bad entries.

Configuration

After you configured data source connectors,

  1. Open the Filter or Validation node
  2. Switch to the String section of the function module
  3. Drag-and-drop the source field and the Match RegExp function to the work panel
  4. Provide the mapping according to the picture below.



  5. Click Ok

Now you can preview data.

See also

     Sample Regular Expressions

     Related forum thread

     RegExp Function

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