| FAQ 941: Grid -- Mask SSNUM in grid for export to clip board |
How do I mask the SS# in the grid to be copied out to excel file?
To display a masked SSN in the grid is by utilizing a formula file. Attached is a formula file that contains a single formula to display the masked SSNs. Copy the file into your \ASC\USER directory, then do the following to reference the formula in a grid:
- When you are choosing the items for your grid and you get to the point where you want to add the masked SSN, click on the "Formulas" button.
- When you are prompted with the Formula Files dialog box, click on the magnifying glass, then select the "maskssn.fme" file and click on the "Open" button. Then click "OK" in the Formula Files dialog to select that file.
- When the MASKEDSSN formula is displayed on the left side of the screen, click on the "Select Item" button to add that formula to your grid.
The formula named MASKEDSSN is as follows:
Format is SocSecNum,12,R,12,CHAR,0
Caveat: If you want to import this again -- this masked SSN now exported is not longer a real SSN and would not match the employee in ASC. If importing use a real SSN or change the Index to NAME or NUMBER.