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.