String Normalizer Apex Action for Salesforce Data Quality

Overview

The String Normalizer is a utility class designed to streamline data standardization within Salesforce. By converting diacritical characters (e.g., "Mélanie" to "Melanie") and normalizing strings, you can significantly enhance your org's duplicate detection logic and overall data integrity.

Core Functionality

The utility provides several methods to manipulate input strings:

• Diacritic Removal: Converts accented characters to their ASCII equivalents.
• Alphanumeric Filtering: Strips non-alphanumeric characters (e.g., "O'brian" becomes "Obrian").
• Space Management: Can either replace special characters with spaces or remove all whitespace.
• Case Normalization: Converts strings to lowercase for consistent comparison or applies proper case formatting.

Technical Implementation

The utility is architected as an Apex class, decoupled from the Invocable Action. This allows developers to consume the logic directly in Apex code or utilize it declaratively via Salesforce Flow.

Use Cases for Developers and Admins

1. Duplicate Detection: Populate custom "ASCII" fields (e.g., FirstNameASCII__c) on Leads or Contacts. Use these fields in Matching Rules to improve match precision.
2. Record Creation: Sanitize input strings before saving to ensure consistency across the database.
3. Batch Processing: Run a batch Apex job to normalize existing records in your Org, backfilling your new custom standardization fields.

Extending the Utility

To make the logic more dynamic, you can move the character mapping logic out of the Apex class and into a Custom Metadata Type or Custom Setting. This allows admins to update normalization rules without modifying the underlying Apex code.

Integration Workflow

For most automation scenarios, the logic can be triggered via:

• Before-Save Flow: Ideal for real-time normalization as records are created or edited.
• Apex Trigger: Recommended for complex logic or bulk processing scenarios where Governor Limits are a concern.
• Batch Apex: Best for high-volume data cleansing or one-time org-wide normalization projects.

Key Takeaways

• Standardization: Use the String Normalizer to handle diacritics and special characters, reducing noise in your data.
• Better Matching: Improve duplicate management by indexing normalized versions of names in custom fields.
• Flexibility: The separation of the Apex utility from the Invocable Action allows for both programmatic and declarative usage.
• Scalability: Consider offloading mapping logic to Custom Metadata to keep your solution maintainable as your character requirements evolve.