Phone

Generates a random telephone number that matches the country or region of the input telephone number, but preserves the format. For example, (123) 456-7890 or 123-456-7890.

If the input is not a valid telephone number, the generator randomly replaces numeric characters. You can also replace invalid numbers with valid numbers.

By default, the numbers are United States telephone numbers.

If the input is a valid telephone number, or if you replace invalid numbers, then the generated numbers pass Google's libphonenumber verification.

Characteristics

Consistency

Yes, can be made self-consistent.

Linking

No, cannot be linked.

Differential privacy

No

Data-free

No

Allowed for primary keys

No

Allowed for unique columns

No

Uses format-preserving encryption (FPE)

No

Privacy ranking

3

Generator ID (for the API)

How to configure

To configure the generator:

  1. Toggle the Replace invalid numbers setting to indicate whether to replace invalid input values with a valid output value. By default, the generator does not replace invalid values. It randomly replaces numeric characters.

  2. Toggle the Consistency setting to indicate whether to make the generator self-consistent. By default, consistency is disabled.

  3. When consistency is enabled, to have Structural ignore formatting when it determines whether two values are the same, toggle Ignore formatting to the on position. For example, the source data includes original values of 1.234.567.8901 and 1 (234) 567 8901. These are the same number, but with different formats. When Ignore formatting is off, then in the output, these values are replaced with different values. When Ignore formatting is on, then these values are replaced with the same number, with the original format preserved. For example, 1.234.567.8901 becomes 1.987.765.4321, and 1 (234) 567 8901 becomes 1 (987) 765 4321.

  4. If Structural data encryption is enabled, then to use it for this column, in the advanced options section, toggle Use data encryption process to the on position.

Last updated

Was this helpful?