Data Masking Components: State Province
Search
OpenNavigationArticle
SSIS Data Masking Components
OpenNavigationArticle
Open Navigation Article
Data Masking Components: State Province
  • Request Trial Request
    a trial
  • Request Demo Request
    a demo
  • Request Quote Request
    a quote

State Province


Purpose

This component identifies whether a value represents a U.S. state or Canadian province and substitutes it with a corresponding value from a valid list, based on the appropriate country. The component validates input values against the ISO 3166-2 standard for country subdivisions, which defines official codes for U.S. states (US-XX) and Canadian provinces (CA-XX).

Key Behaviors:

  • Determines if the input is a U.S. state or Canadian province
  • Substitutes values using the corresponding list of valid state/province names or codes
  • Preserves the original format (e.g., full name or abbreviation)

The Random version replaces each input with a randomly selected valid state or province from either country. The substitution can vary each time the process is run and does not preserve referential integrity.

Algorithm

Variation of Random Character Permutation Algorithm

TutorialIcon Go to Tutorial

Data Masking Components: State Province

DownloadUserGuide Download Manual
About Hush-Hush Contact Us

E-mail: info@mask-me.net

tel: 855.968.4874

Privacy Policy Terms of Use