Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Data Pattern Search Template

Free download

Posted by: Informatica Cloud

The data pattern search template search for patterns across all fields and returns a concatenated list of fields that matches the respective pattern. The pattern search makes use of the REGEX (Regular Expression) function.


The Data Pattern Search Template can be used to search for patterns such as emails, phone numbers, dates, and more. The Template uses a REGEX (Regular Expression) matching algorithm to search for the data. The template can be used to identify relevant fields in unknown data sources that have the specific data patterns you are looking for. Users can leverage this template for a variety of use cases such as:


  • Searching & replacing certain patterns of strings.
  • Detecting irregularities in a set of data.
  • Discovering contact information such as email, phone, address, etc.
  • Verifying that data has been input in the proper format.


  • Must have minimum of Informatica Cloud Basic Edition or higher installed to consume template.


Comments Comments (0)