Functions for masking concatenated fields
These function options may be applied on multiple fields selected in the grid of the Columns pane. They implement a combination of conversion, concatenation and mask formatting. We list next all the mask format functions:
Phone [LO] : 1-999-999-9999 |
Long phone number with local and area codes, the concatenation is assumed to be an 11-character string. |
Phone [LO] : 1 999-999-9999 |
Long phone number with local and area codes, the concatenation is assumed to be an 11-character string. |
Phone [AC] : (999) 999-9999 |
Phone number with area code, the concatenation is assumed to be 10-character string. |
Phone [AC] : 999-999-9999 |
Phone number with area code, the concatenation is assumed to be 10-character string. |
Phone [AC] : 999.999.9999 |
Phone number with area code, the concatenation is assumed to be 10-character string. |
Phone [ACX]: (999) 999-9999 (ext 00000) |
Phone number with area code and extension, the concatenation is assumed to be more than 10-character string. |
Phone [SH] : 999-9999 |
Short phone number, the concatenation is assumed to be 7-character string. |
Area Code : (999) |
Area code, storage is assumed to be 3-character string |
Extension : (ext 00000) |
Extension |
Extension : -X00000 |
Extension |
SS# : 999-99-9999 |
Social security number, storage is assumed to be 9-character string. |
Fed ID : 99-9999999 |
Federal ID, storage is assumed to be 9-character string. |
Zip Code : 99999-9999 |
Zip code, storage is assumed to be 9-character string. |
Bank Acc : 99999-99999 |
Bank account number, storage is assumed to be 10-character string. |
Cred Card : 9999-9999-9999-9999 |
Credit card number, storage is assumed to be 16-character string. |
ISBN : 9-99-999999-9 |
ISBN, storage is assumed to be 10-character string. |
ISBN : 9-999-99999-9 |
ISBN, storage is assumed to be 10-character string. |
ISBN : 9-9999-9999-9 |
ISBN, storage is assumed to be 10-character string. |
ISBN : 9-99999-999-9 |
ISBN, storage is assumed to be 10-character string. |
ISBN : 9-999999-99-9 |
ISBN, storage is assumed to be 10-character string. |