- Home
- Developer Center
- Documentation SSIS Data Masking Components
- US Phone Nu Dynamic
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- US Phone Nu Dynamic
US Phone Nu Dynamic
Purpose
This version replaces numeric digits in U.S. phone numbers while preserving the original format, country code, area code, and separators, including formats like:
- 123-456-7890 → 123-203-5691
- 123.456.7890 → 123-203-5691
- (123) 456-7890 → (123) 144-6451
- 123 456 7890 → 123 835 2461
- +1(123) 456-7890 → +1(123) 144-6451
All formatting characters are preserved exactly as in the original input. Only numeric digits are masked, and alphabetic characters are not accepted.
The component verifies that phone numbers contain exactly 10 numeric digits (xxx xxx xxxx) or country code + 10 numeric digits (+1 xxx xxx xxxx). Numbers with more or fewer digits result in an error.
This version ensures referential integrity: the same original phone number will always produce the same masked output within a dataset.
The area code is preserved. The component does not check for valid or existing area codes.
Algorithm
Variation of Random Character Permutation Algorithm
Data Masking Components: US Phone Nu Dynamic