Masking rules

Owned by Alexey Sosnovskih
Last updated: Aug 13, 2024 by Dima Urban (Unlicensed)
13 min read

Masking rules

 

The masking rule is a critical component of data masking service, which refers to the process of obscuring original data within a database to protect sensitive information.

Here's a high-level description of what a masking rule consists:

 

Definition

A masking rule defines specific methods or algorithms used to detect, replace, scramble, modify, or otherwise obscure sensitive data. It's a set of instructions that governs how the original data should be detected and transformed to ensure that the underlying information remains confidential.

Components


Detector:

Defines the logic and conditions under which data is considered sensitive and therefore subject to masking. This could be based on the fetched data samples, data patterns, data types, column names, or other attributes.


Masking Function:

Specifies the algorithm or logic used to transform the original data. This can include multiple techniques such as substitution, shuffling, encryption, etc.


Parameters:

These are configurable options within the masking rule that allow customization of the masking behavior. For example, the number of characters to keep unchanged or the deviation from original value


Examples and Tags:

Some masking rules may include examples of how the rule works or tags to categorize the type of data being masked (e.g., Personal, Financial).

 

Masking rules

Updates history

New rule

Description

Author

Date

New rule

Description

Author

Date

1

  • Mask Reversible (Any Value)

  • Unmask Reversible (Any Value)

  • Unmask Reversible (Any Value (numeric))

  • Mask Reversible (Any Value (numeric))

These rules provide ability to mask and unmask database values (numeric and text), allowing for reversible masking. This feature gives users full control over the masking process, including the capability to rollback any masking actions, consistent masking across different tables and different databases, enhancing data management flexibility.

@Dima Urban (Unlicensed)

Aug 12, 2024

release v30

2

  • Calculated Field

Calculated Field Rule enhancement expands our data privacy capabilities by enabling cross-column masking functionality and offering users the ability to create complex masking rules with an advanced JavaScript-based expression builder.

@Dima Urban (Unlicensed)

Aug 12, 2024

release v 27

3

  • Email in Text

Allow to mask emails by regex in free text

@Dima Urban (Unlicensed)

Aug 12, 2024

release v33

Built-in rules v 36

 

 

 

Name

description

col. type

col. size

Masking function

Parameters

examples

tags

detector type

Name

description

col. type

col. size

Masking function

Parameters

examples

tags

detector type

1

Account Number

Mask Account Number

CHAR

1

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["123456789", "   ->   ", "277547817"]

["Personal", "Column"]

COLUMN_REGEX

2

Admission Date

Mask Admission Date

DATE

0

MaskDate

[{"name": "Deviation (Days)", "description": "MAX possible deviation (in days)", "type": "NUMBER", "value": "30"}]

["01/01/2021", "   ->   ", "30/01/2021"]

["Date", "Column"]

COLUMN_REGEX

3

Any Value

Mask any strings

CHAR

1

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Trim before mask", "description": "Trim whitespace from data before masking", "type": "BOOLEAN", "value": "False"}]

["pTVWc63", "   ->   ", "uBTIs54"]

["Basic", "Column"]

COLUMN_REGEX

4

Any Value (numeric)

Mask any numeric value

NUMERIC

0

MaskAnyValueNum

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["1482543", "   ->   ", "3796274"]

["Basic", "Column"]

COLUMN_REGEX

5

Bank Account / Swift Number

Mask Bank Account / Swift Number

CHAR

8

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "4"}]

["AAAABBCC123", "     ->     ", "BCDEFGHJ456"]

["USA", "Bank"]

DATA_REGEX

6

Bitcoin Address

Mask Bitcoin Address

CHAR

6

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "2"}]

["C8B9FC507B27D1C194B7F2EBE4941A25FA289BF790EBEFAB874F937ADE3EE403", "     ->     ", "C1B9FC507B27D1C194B7F2EBE4941A25F2289BF790EBEFAB874F9373DE3EE403"]

["Personal"]

DATA_REGEX

7

Brazilian City Names

List of Brazilian City Names

CHAR

24

MaskList

 

["Salvador", "     ->     ", "Sabar\u00e1"]

["List", "BRA"]

DATA_LOOKUP

8

Calculated Field

Masks a column based on other columns and a JavaScript expression

NUMERIC

100

MaskCalcFields

[{"name": "expression", "description": "JS expression for calculations", "type": "STRING", "value": ""}]

["[(ID)] + 'test_value' + [(col_0_22)] + '_suffix", "   ->   ", "[(table_1.number)] * 10 + [(table_1.col_0)] + '_suffix"]

["IT"]

NONE

9

CC Exp. Date (Column)

Mask Credit Card Expiration Date

CHAR

5

MaskCCExpDate

 

["12/21", "   ->   ", "09/24"]

["Column", "Bank"]

COLUMN_REGEX

10

CC Sec. Code (Column)

Mask Credit Card Security Code

CHAR

3

MaskCreditCardSecurityCode

 

["123", "   ->   ", "469"]

["Bank", "Column"]

COLUMN_REGEX

11

Certificate Number

Mask Certificate Number

CHAR

1

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["123456789", "   ->   ", "277547817"]

["Personal", "Column"]

COLUMN_REGEX

12

Countries

List of Country Names 

CHAR

40

MaskList

 

["Runion", "     ->     ", "Bermuda"]

["List"]

DATA_LOOKUP

13

Credit Card

Mask Credit Card Number

CHAR

12

MaskCreditCard

[{"name": "Issuer Length", "description": "Number of unchanged digits (from 4 to 6)", "type": "NUMBER", "value": "4"}, {"name": "Changed Part", "description": "Number of digits to replace", "type": "NUMBER", "value": "7"}]

["340010654300068", "     ->     ", "340041000000011"]

["Personal", "Bank"]

DATA_REGEX

14

D.O.B

Mask the date of D.O.B.

DATE

0

MaskDate

[{"name": "Deviation (Days)", "description": "MAX possible deviation (in days)", "type": "NUMBER", "value": "30"}]

["01/01/2021", "   ->   ", "30/01/2021"]

["Date"]

COLUMN_REGEX

15

Date

Mask date

DATE

0

MaskDate

[{"name": "Deviation (Days)", "description": "MAX possible deviation (in days)", "type": "NUMBER", "value": "30"}]

["01/06/2021", "   ->   ", "01/07/2021"]

["Date"]

DATA_REGEX

16

Death Date

Mask Death Date

DATE

0

MaskDate

[{"name": "Deviation (Days)", "description": "MAX possible deviation (in days)", "type": "NUMBER", "value": "30"}]

["01/05/2021", "   ->   ", "30/05/2021"]

["Date", "Column"]

COLUMN_REGEX

17

Discharge Date

Mask Discharge Date

DATE

0

MaskDate

[{"name": "Deviation (Days)", "description": "MAX possible deviation (in days)", "type": "NUMBER", "value": "30"}]

["01/11/2021", "   ->   ", "04/11/2021"]

["Date", "Column"]

COLUMN_REGEX

18

Driving License (Column)

Mask Driving License

CHAR

7

MaskAnyValue

 

["G544061739250", "   ->   ", "T903345827041"]

["Column", "Personal"]

COLUMN_REGEX

19

Email

Mask Email Address

CHAR

10

MaskEmail

[{"name": "Keep Domain Name", "description": "The masked email will have the same domain name", "type": "BOOLEAN", "value": "True"}, {"name": "Multiple Value Separators", "description": "Used to split multiple emails of single value", "type": "STRING", "value": ",;"}]

["admin@gmail.com", "       ->      ", "zzuzy@gmail.com"]

["Personal"]

DATA_REGEX

20

Email in Text

Mask Email Address that included into the text

CHAR

10

MaskEmailAmongString

[{"name": "Keep Domain Name", "description": "The masked email will have the same domain name", "type": "BOOLEAN", "value": "True"}]

["some additional test with admin@gmail.com was provided", "       ->      ", "some additional test with zzuzy@gmail.com was provided"]

["Personal"]

DATA_REGEX

21

Fix String Value

Replaces all data values of a column to a fix string

CHAR

1

MaskToFixString

[{"name": "Fix String", "description": "Fix string to replace all values in a column", "type": "STRING", "value": " "}]

["password1234", "   ->   ", "************"]

["Basic", "Column"]

COLUMN_REGEX

22

French City Names

List of French City Names

CHAR

25

MaskList

 

["Montaigu-Vend\u00e9e", "   ->   ", "Saint-Rapha\u00ebl"]

["List", "FRA"]

DATA_LOOKUP

23

French First Names

List of French First Names

CHAR

13

MaskList

 

["Hugo", "     ->     ", "Thomas"]

["List", "FRA"]

DATA_LOOKUP

24

French Full Names

List of French Full Names

CHAR

25

MaskFullName

 

["Kylian Lambert", "   ->   ", "Emy Dubourg"]

["List", "FRA"]

DATA_FULL_NAME

25

French Last Names

List of French Last Names

CHAR

11

MaskList

 

["Michel", "     ->     ", "Lemaire"]

["List", "FRA"]

DATA_LOOKUP

26

GBR Address (Column)

Mask GBR Address (Column)

CHAR

23

MaskEnglishFullAddress

 

["14 High Street", "     ->     ", "84 Queensway"]

["Column", "GBR"]

COLUMN_REGEX

27

GBR City Names

List of GBR City Names

CHAR

19

MaskList

 

["Chester", "     ->     ", "Basildon"]

["List", "GBR"]

DATA_LOOKUP

28

GBR County Names

List of GBR County Names

CHAR

18

MaskList

 

["Lancashire", "     ->     ", "Carmarthenshire"]

["List", "GBR"]

DATA_LOOKUP

29

GBR First Names

List of GBR First Names

CHAR

11

MaskList

 

["David", "     ->     ", "Brandon"]

["List", "GBR"]

DATA_LOOKUP

30

GBR Full Names

List of GBR Full Names

CHAR

22

MaskFullName

 

["John Baron", "     ->     ", "George Shaw"]

["List", "GBR"]

DATA_FULL_NAME

31

GBR Full Street Name

GBR Full Street Name

CHAR

23

MaskEnglishFullAddress

 

["14 High Street", "     ->     ", "84 Queensway"]

["GBR", "List"]

DATA_STREETS

32

GBR Last Names

List of GBR Last Names

CHAR

10

MaskList

 

["Smith", "     ->     ", "Gibson"]

["List", "GBR"]

DATA_LOOKUP

33

GBR National Insurance No.

GBR National Insurance number (NINO)

CHAR

9

MaskGBRNINO

 

["AA123456C", "   ->    ", "SS792617B"]

["Personal", "GBR"]

DATA_REGEX

34

GBR Phone No.

Mask GBR Phone Number

CHAR

16

MaskPhoneNo

[{"name": "Operator Length", "description": "Number of unchanged digits", "type": "NUMBER", "value": "5"}]

["(020) 4674 2459", "      ->      ", "(020) 4642 3955"]

["Personal", "GBR"]

DATA_PHONE

35

GBR Postcode

GBR Postcode

CHAR

8

MaskGBRPostcode

[{"name": "Skip first digits", "description": "Keep first # of digits", "type": "NUMBER", "value": "4"}]

["EC1A 1BB", "   ->   ", "EC1A 2YY"]

["GBR"]

DATA_REGEX

36

Germany City Names

List of Germany City Names

CHAR

21

MaskList

 

["Berlin", "     ->     ", "G\u00f6ttingen"]

["List", "DEU"]

DATA_LOOKUP

37

Germany First Names

List of Germany First Names

CHAR

17

MaskList

 

["G\u00fcnter", "     ->     ", "Tina"]

["List", "DEU"]

DATA_LOOKUP

38

Germany Full Names

List of Germany Full Names

CHAR

29

MaskFullName

 

["Wolfgang Sch\u00e4fer", "     ->     ", "Josef Krause"]

["List", "DEU"]

DATA_FULL_NAME

39

Germany Last Names

List of Germany Last Names

CHAR

12

MaskList

 

["Bischoff", "     ->     ", "Drews"]

["List", "DEU"]

DATA_LOOKUP

40

Health Insurance Claim Number (HICN)

Health Insurance Claim Number (HICN)

CHAR

14

MaskHICN

 

["123-45-6789-A", "   ->   ", "025-94-0754-T"]

["Personal", "USA"]

DATA_REGEX

41

Height

HIPAA Data Item

CHAR

4

MaskDigitsOnly

[{"name": "Skip first digit(s)", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "1"}]

["2'4\"", "     ->     ", "6'0\""]

["Personal", "USA"]

DATA_REGEX

42

IBAN

Mask International Bank Account Number (IBAN)

CHAR

20

MaskIBAN

[{"name": "Keep Country Code", "description": "The masked number will have the same country code", "type": "BOOLEAN", "value": "True"}]

["MK07300000000042425", "         ->        ", "SI56191000000123438"]

["Personal", "Bank"]

DATA_REGEX

43

ID Israeli

Mask ID (Teudat Zehut)

CHAR

8

MaskIdIsr

[{"name": "Skip first digits", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "0"}]

["123456789", "   ->   ", "914839642"]

["Personal", "ISR"]

DATA_REGEX

44

ID Israeli (numeric)

Mask ID (Teudat Zehut)

NUMERIC

0

MaskIdIsrNum

[{"name": "Skip first digits", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "0"}]

["123456789", "   ->   ", "914839642"]

["Personal", "ISR"]

DATA_REGEX

45

Indian City Names

List of Indian City Names

CHAR

21

MaskList

 

["Mumbai", "     ->     ", "Purnia"]

["List", "IND"]

DATA_LOOKUP

46

Indian First Names

List of Indian First Names

CHAR

10

MaskList

 

["Ashok", "     ->     ", "Vijay"]

["List", "IND"]

DATA_LOOKUP

47

Indian Full Names

List of Indian Full Names

CHAR

22

MaskFullName

 

["Ashok Mandal", "     ->     ", "Jitendra Patra"]

["List", "IND"]

DATA_FULL_NAME

48

Indian Last Names

List of Indian Last Names

CHAR

11

MaskList

 

["Kumar", "     ->     ", "Verma"]

["List", "IND"]

DATA_LOOKUP

49

Indian States

List of Indian States

CHAR

16

MaskList

 

["Goa", "     ->     ", "Uttarakhand"]

["List", "IND"]

DATA_LOOKUP

50

IPv4 address

Mask Internet Protocol Address (IPv4 address)

CHAR

15

MaskIpAddress

 

["192.168.1.1", "     ->     ", "172.31.8.233"]

["IT"]

DATA_REGEX

51

IPv6 address

Mask Internet Protocol Address (IPv6 address)

CHAR

15

MaskIPv6

 

["0f10:3142:6374:95a6:c7d8:f90a:2b3c:5d6e4", "     ->     ", "9d79:7117:1955:57b5:b3b5:b75d:5f9f:3f5d"]

["Personal", "IT"]

DATA_REGEX

52

Israeli City Names

List of Israeli City Names

CHAR

18

MaskList

 

["\u05d0\u05d9\u05dc\u05ea", "     ->     ", "\u05d0\u05d5\u05e4\u05e7\u05d9\u05dd"]

["List", "ISR"]

DATA_LOOKUP

53

Israeli Country Names

List of Israeli Country Names

CHAR

27

MaskList

 

["\u05d1\u05e0\u05d2\u05dc\u05d3\u05e9", "     ->     ", "\u05de\u05e7\u05d3\u05d5\u05e0\u05d9\u05d4\u05d4"]

["List", "ISR"]

DATA_LOOKUP

54

Israeli First Names

List of Israeli First Names

CHAR

8

MaskList

 

["\u05d0\u05e1\u05ea\u05e8", "     ->     ", "\u05e0\u05ea\u05df"]

["List", "ISR"]

DATA_LOOKUP

55

Israeli Full Names

List of Israeli Full Names

CHAR

20

MaskFullName

 

["\u05e8\u05d5\u05e2\u05d9 \u05d1\u05e0\u05d9\u05d9\u05de\u05d9\u05df", "     ->     ", "\u05e8\u05d7\u05dc \u05e9\u05d5\u05d5\u05e8\u05e5"]

["List", "ISR"]

DATA_FULL_NAME

56

Israeli Last Names

List of Israeli Last Names

CHAR

11

MaskList

 

["\u05d0\u05d5\u05d7\u05d9\u05d5\u05df", "     ->     ", "\u05de\u05e0\u05e9\u05d4"]

["List", "ISR"]

DATA_LOOKUP

57

Israeli Phone No.

Mask Israeli Phone Number

CHAR

6

MaskPhoneNo

[{"name": "Operator Length", "description": "Number of un-changed digits", "type": "NUMBER", "value": "4"}]

["(080)-4020-3797", "     ->     ", "(080)-4271-7463"]

["ISR", "Personal"]

DATA_PHONE

58

Israeli Street Name

List of Israeli Street Name

CHAR

16

MaskList

 

["\u05d4\u05e8\u05e6\u05dc", "     ->     ", "\u05d1\u05d9\u05d0\u05dc\u05d9\u05e7"]

["List", "ISR"]

DATA_LOOKUP

59

Italian City Names

List of Italian City Names

CHAR

23

MaskList

 

["Trani", "     ->     ", "Vicenza"]

["List", "ITA"]

DATA_LOOKUP

60

Italian First Names

List of Italian First Names

CHAR

10

MaskList

 

["Silvia", "     ->     ", "Erika"]

["List", "ITA"]

DATA_LOOKUP

61

Italian Full Names

List of Italian Full Names

CHAR

23

MaskFullName

 

["Alice Pagano", "     ->     ", "Chiara Ferrari"]

["List", "ITA"]

DATA_FULL_NAME

62

Italian Last Names

List of Italian Last Names

CHAR

12

MaskList

 

["Costa", "     ->     ", "Parisi"]

["List", "ITA"]

DATA_LOOKUP

63

License Number

Mask License Number

CHAR

1

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["567892345", "   ->   ", "622983463"]

["Personal", "Column"]

COLUMN_REGEX

64

License Plate

Mask Israeli vehicle registration plate No.

CHAR

6

MaskLicensePlateIsr

[{"name": "Keep Manufacture Year", "description": "The last two digits will stay the same", "type": "BOOLEAN", "value": "True"}]

["123-45-678", "   ->   ", "220-05-249"]

["ISR"]

DATA_REGEX

65

MAC address

Mask media access control address (MAC address)

CHAR

12

MaskMacAddress

 

["00-08-20-83-53-D1", "     ->     ", "12-58-25-32-56-A2"]

["IT"]

DATA_REGEX

66

Mask Reversible (Any Value (numeric))

Mask reversible any numeric value

NUMERIC

0

MaskAnyValueNumReversible

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["1482543", "   ->   ", "3796274"]

["Basic", "Column"]

COLUMN_REGEX

67

Mask Reversible (Any Value)

Mask reversible any strings

CHAR

1

MaskAnyValueReversible

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["pTVWc63", "   ->   ", "uBTIs54"]

["Basic", "Column"]

COLUMN_REGEX

68

Medical Record Number (MRN)

Medical Record Number (MRN)

CHAR

6

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["123456", "   ->   ", "796166"]

["Personal", "Column"]

COLUMN_REGEX

69

Medicare Beneficiary Identifier (MBI)

Medicare Beneficiary Identifier (MBI)

CHAR

11

MaskMBI

 

["1EG4TE5MK72", "   ->   ", "2RP5CR6TY83"]

["Personal"]

DATA_REGEX

70

Passport Number (Column)

Mask Passport Number

CHAR

9

MaskPassportNo

 

["894562751", "   ->   ", "796056726"]

["Column", "Personal"]

COLUMN_REGEX

71

Phone Number

Mask Phone Number

CHAR

6

MaskPhoneNo

[{"name": "Operator Length", "description": "Number of un-changed digits", "type": "NUMBER", "value": "4"}]

["(080)-4020-3797", "     ->     ", "(080)-4271-7463"]

["Personal"]

DATA_REGEX

72

Phone Number (Column)

Mask Phone Number (Column)

CHAR

6

MaskPhoneNo

[{"name": "Operator Length", "description": "Number of unchanged digits", "type": "NUMBER", "value": "4"}]

["(080)-4020-3797", "     ->     ", "(080)-4811-8750"]

["Personal", "Column"]

COLUMN_REGEX

73

Phone Number Numeric (Column)

Mask Phone Number Numeric (Column)

NUMERIC

0

MaskPhoneNumberNumeric

[{"name": "Operator Length", "description": "Number of unchanged digits", "type": "NUMBER", "value": "4"}]

["550412345", "     ->     ", "550468150"]

["Personal", "Column"]

COLUMN_REGEX

74

Portuguese City Names

List of Portuguese City Names

CHAR

26

MaskList

 

["Anadia", "     ->     ", "Leiria"]

["List", "PRT"]

DATA_LOOKUP

75

Portuguese First Names

List of Portuguese First Names

CHAR

10

MaskList

 

["Luis", "     ->     ", "Daniela"]

["List", "PRT"]

DATA_LOOKUP

76

Portuguese Full Names

List of Portuguese Full Names

CHAR

20

MaskFullName

 

["Luis Pinto", "     ->     ", "Verinha Moreira"]

["List", "PRT"]

DATA_FULL_NAME

77

Portuguese Last Names

List of Portuguese Last Names

CHAR

9

MaskList

 

["Costa", "     ->     ", "Carvalho"]

["List", "PRT"]

DATA_LOOKUP

78

Serial Number

Mask Serial Number

CHAR

1

MaskAnyValue

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["123456789", "   ->   ", "277547817"]

["Personal", "Column"]

COLUMN_REGEX

79

Spanish City Names

List of Spanish City Names

CHAR

24

MaskList

 

["Valencia de Alc\u00e1ntara", "     ->     ", "Olite"]

["List", "ESP"]

DATA_LOOKUP

80

Spanish First Names

List of Spanish First Names

CHAR

9

MaskList

 

["Isaac", "     ->     ", "Isabel"]

["List", "ESP"]

DATA_LOOKUP

81

Spanish Full Names

List of Spanish Full Names

CHAR

21

MaskFullName

 

["Axel Torregrosa", "     ->     ", "Hector Parada"]

["List", "ESP"]

DATA_FULL_NAME

82

Spanish Last Names

List of Spanish Last Names

CHAR

11

MaskList

 

["Rodrigo", "     ->     ", "Soria"]

["List", "ESP"]

DATA_LOOKUP

83

SSN

Social Security number

CHAR

9

MaskSSN

[{"name": "Skip first digits", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "3"}]

["187-05-1120", "   ->   ", "187-54-5195"]

["Personal", "USA"]

DATA_REGEX

84

SSN (Column)

Social Security number (Column)

CHAR

9

MaskSSN

[{"name": "Skip first digits", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "3"}]

["187-05-1120", "   ->   ", "187-54-5195"]

["Personal", "Column", "USA"]

COLUMN_REGEX

85

SSN (Numeric Column)

Social Security number for numeric fields

NUMERIC

0

MaskSSNNum

[{"name": "Skip first digits", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "3"}]

["187-05-1120", "   ->   ", "187-54-5195"]

["Personal", "USA", "Column"]

COLUMN_REGEX

86

SSN (Numeric)

Social Security number for numeric fields

NUMERIC

0

MaskSSNNum

[{"name": "Skip first digits", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "3"}]

["187-05-1120", "   ->   ", "187-54-5195"]

["Personal", "USA"]

DATA_REGEX

87

Turkish City Names

List of Turkish City Names

CHAR

16

MaskList

 

["Istanbul", "     ->     ", "Varto"]

["List", "TUR"]

DATA_LOOKUP

88

Turkish First Names

List of Turkish First Names

CHAR

16

MaskList

 

["Mustafa", "     ->     ", "Zehra"]

["List", "TUR"]

DATA_LOOKUP

89

Turkish Full Names

List of Turkish Full Names

CHAR

29

MaskFullName

 

["Yusuf Kaya", "     ->     ", "Emine Akkurt"]

["List", "TUR"]

DATA_FULL_NAME

90

Turkish Last Names

List of Turkish Last Names

CHAR

12

MaskList

 

["Ayd\u0131n", "     ->     ", "\u00dclker"]

["List", "TUR"]

DATA_LOOKUP

91

Unmask Reversible (Any Value (numeric))

Reverse any numeric value from a masked value by 'Mask Reversible (Any Value (numeric))'

NUMERIC

0

MaskAnyValueNumFromMasked

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["3796274", "   ->   ", "1482543"]

["Basic", "Column"]

COLUMN_REGEX

92

Unmask Reversible (Any Value)

Reverse any strings from a masked value by 'Mask Reversible (Any Value)'

CHAR

1

MaskAnyValueFromMasked

[{"name": "Skip first symbols", "description": "Number of first unchanged symbols", "type": "NUMBER", "value": "0"}, {"name": "Skip last symbols", "description": "Number of last unchanged symbols", "type": "NUMBER", "value": "0"}]

["uBTIs54", "   ->   ", "pTVWc63"]

["Basic", "Column"]

COLUMN_REGEX

93

URL

Mask Uniform Resource Locator (URL)

CHAR

15

MaskURL

[{"name": "Keep Protocol", "description": "Keep the same protocol (if it specified)", "type": "BOOLEAN", "value": "True"}, {"name": "Cut Path", "description": "Cut the path to make the URL shorter", "type": "BOOLEAN", "value": "True"}, {"name": "Cut Query", "description": "Cut the query to make the URL shorter", "type": "BOOLEAN", "value": "True"}]

["http://pen.io/key.jsp?id=v12", "   ->   ", "https://gov.is"]

["IT"]

DATA_REGEX

94

USA City Names

List of USA City Names

CHAR

16

MaskList

 

["McAllen", "     ->     ", "Dayton"]

["List", "USA"]

DATA_LOOKUP

95

USA County Names

List of USA County Names

CHAR

23

MaskList

 

["Los Angeles", "     ->     ", "Maricopa"]

["List", "USA"]

DATA_LOOKUP

96

USA First Names

List of USA First Names

CHAR

11

MaskList

 

["Thomas", "     ->     ", "Justin"]

["List", "USA"]

DATA_LOOKUP

97

USA Full Address (Column)

Mask USA Full Address

CHAR

15

MaskEnglishFullAddress

 

["11 08TH AVE", "     ->     ", "11 Corley Dr"]

["Column", "USA"]

COLUMN_REGEX

98

USA Full Names

List of USA Full Names

CHAR

22

MaskFullName

 

["Bobby Fischer", "     ->     ", "Adam Rodriguez"]

["List", "USA"]

DATA_FULL_NAME

99

USA Full Street Name

Mask USA Full Street Name

CHAR

15

MaskEnglishFullAddress

 

["Karakoram Highway", "     ->     ", "23 Boley St"]

["USA"]

DATA_STREETS

100

USA Inc 5000

List of USA Inc 5000 company names

CHAR

36

MaskList

 

["Human Bees", "     ->     ", "Viking Painting"]

["List", "USA"]

DATA_LOOKUP

101

USA Last Names

List of USA Last Names

CHAR

10

MaskList

 

["Foster", "     ->     ", "Alvarez"]

["List", "USA"]

DATA_LOOKUP

102

USA Phone No.

Mask USA Phone Number

CHAR

14

MaskPhoneNo

[{"name": "Operator Length", "description": "Number of un-changed digits", "type": "NUMBER", "value": "4"}]

["+1-646-479-5706", "     ->     ", "+1-646-260-0769"]

["Personal", "USA"]

DATA_PHONE

103

USA States

List of USA States

CHAR

20

MaskList

 

["Arkansas", "     ->     ", "Alaska"]

["List", "USA"]

DATA_LOOKUP

104

USA Street Names (Column)

Mask USA Street Names

CHAR

15

MaskList

 

["08TH AVE", "     ->     ", "Main Street"]

["USA", "Column"]

COLUMN_REGEX

105

User ID

Mask User ID

CHAR

6

MaskUserID

[{"name": "Unchanged prefix", "description": "Number of unchanged characters", "type": "NUMBER", "value": "0"}]

["ADM00005", "   ->   ", "CRM39287"]

["Personal", "Business", "Column"]

COLUMN_REGEX

106

User Name

Mask User Name

CHAR

2

MaskUsername

 

["admin", "   ->   ", "uzwax"]

["Personal", "IT", "Column"]

COLUMN_REGEX

107

VIN

Mask Vehicle Identification Number (VIN)

CHAR

5

MaskVIN

[{"name": "Keep manufacturer", "description": "Keep the manufacturer ID (first 3 chars)", "type": "BOOLEAN", "value": "True"}]

["1FMFK15518LA00707", "      ->     ", "1NXBR12E02Z573839"]

["Car"]

DATA_REGEX

108

Weight

HIPAA Data Item

CHAR

2

MaskDigitsOnly

[{"name": "Skip first digit(s)", "description": "Number of first unchanged digits", "type": "NUMBER", "value": "1"}]

["65.5", "     ->     ", "68.0"]

["Personal", "USA"]

DATA_REGEX

109

Zip+4 Code

Mask Zip+4 Code

CHAR

6

MaskAnyValue

 

["99577-0727", "     ->     ", "52673-3514"]

["Personal", "USA"]

DATA_REGEX