 | 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,
- Open the Filter or Validation node
- Switch to the String section of the function module
- Drag-and-drop the source field and the Match RegExp function to the work panel
- Provide the mapping according to the picture below.
- Click Ok
Now you can preview data.
See also
Sample Regular Expressions
Related forum thread 
RegExp Function