Replace values

Data Integrity Suite
Product
Spatial_Analytics
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2025

Use the Replace Values action to replace any value in a pipeline with a different value. You can choose from three search methods: Literal, Mask, or Regular Expression, depending on your cleansing needs.

To add a Replace Values action
  1. In the Cleanse Data step, click + Add Action.
  2. From the dropdown, select Replace Values.
  3. From the Field dropdown, choose the field you want to clean.
  4. Under Search Method, select one of the following options:
    • Literal
    • Mask
    • Regular Expression

Search Method: Literal

Use Literal to match and replace exact text values.
  1. Choose the operator available for the Exact match from the drop-down:
    • Equals
    • Contains
    • Starts with
    • Ends with
  2. Replace section: For each row:
    • Enter a Search Value.
    • Enter a Replacement Value.

  3. You can enable case sensitivity for the operator in the Settings options.

  4. To replace any value with a space or a tab, simply select the desired option from the Ellipses icon menu.

Note: In the Literal search method, selecting the Starts with, Ends with or Equals option automatically hides the Occurrence selection.

Example:

Table 1.
Exp Replacement Before After
United States USA United States USA

Search Method: Mask

Use Mask to define pattern-based matches using wildcards.
  1. Replace section: In each row:
  2. Enter a Mask Pattern in Search Value
  3. Enter a Replacement Value
Example:
Table 2.
Exp Replacement Before After
NNN ### 253-09-0023 ###-09-0023

Search Method: Regular Expression

Use Regular Expression to apply advanced pattern matching.
  1. Replace section: In each row:
  2. Enter a Regular Expression in Search Value
  3. Enter a Replacement Value
Example:
Table 3.
Exp Replacement Before After
[\w.-]+@[\w.-]+\w+ [EMAIL REDACTED] john.doe@test.com [EMAIL REDACTED]
Tip:
  • Regular expressions follow standard regex syntax.
  • Use anchors (^, $), groups, or quantifiers as needed.
  • Make sure expressions are tested for correctness, as incorrect patterns may produce no replacements.

Finalizing the Action

Once all replacement rows are added:
  1. Review the rows for accuracy.
  2. Define the occurrence to accurately count and replace each instance independently within individual fields.
  3. Click Apply to save the action.
  4. The action now appears in the Cleanse Data step's action list.

You can add multiple Replace Values actions, each with a different field or search method.