Skip to main content
Version: 2

Regex

  • Category​

    • Design

    • Transformation

  • Flow Icon​

Overview​

The Regex component in Plinqx is crafted to apply regular expressions to a given input string for various transformation purposes. This component is extremely useful for pattern matching, data extraction, validation, and string manipulation tasks within your flows.

Inputs​

  1. inputString:

    The string on which the regular expression will be applied.

  2. inRegEx:

    The regular expression pattern to use for the transformation or validation.

  3. replace:

    A boolean value indicating whether to replace the matched pattern in the string (True) or simply perform a match (False).

Outputs​

  1. outPutResult:

    The result of applying the regex to the input string. This could be the transformed string (if replace is True) or the matched pattern.

Example Scenario - Formatting Phone Numbers​

Scenario Overview:

In a Salesforce org, phone numbers are collected through various means and often have inconsistent formats. A flow is needed to standardize these phone numbers into a uniform format before they are stored in the system.

Implementation with Regex Component:

  1. Flow Setup for Phone Number Formatting:

    • Create a Salesforce flow that triggers when new phone number data is entered or imported into the system.

  2. Adding Regex Component:

    • Incorporate the Regex component into the flow to format the phone numbers.

  3. Configuring Inputs:

    • 'inputString' is set to the captured phone number.

    • 'inRegEx' is defined with a regular expression pattern that matches various phone number formats.

    • 'replace' is set to True to enable the transformation of the phone number into a standardized format.

  4. Executing Regex Transformation:

    • The flow processes each phone number, applying the regex to transform it into a consistent format.

  5. Using Transformed Data:

    • The 'outPutResult' provides the standardized phone number, which is then used for updating records in Salesforce.

Results:

Implementing the Regex component allows the Salesforce org to efficiently standardize phone numbers into a uniform format. This approach ensures data consistency, improves data quality, and enhances the usability of contact information within the system.