Masking a field on the screen

[Richard Kreiss]

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Rami Mantoura
> via Filepro-list
> Sent: Wednesday, August 23, 2017 9:38 AM
> To: FilePro Mailing List <filepro-list at lists.celestial.com>
> Subject: Masking a field on the screen
> 
> Hi All,
> 
> I know I should know this answer, but My mind is blank on this.
> 
> Is there a way of masking a field (Like SS#) without coding it on a screen.
> 
> I know there is a password function when doing an input command, but can't
> seem to find anything on this.
> 
> I would like to display either the first 3 char or last 4 char (or something like
> that).
> 
> Thanks
> Rami

There are a couple of solutions to this question.

1. In auto processing or @entsel create a dummy field to display what you want.  Use a md() to get the values to display, an place the dummy field on the screen where you want it.
Example: a social security # nnn nn nnnn. With the spaces this is a 12 character value.  Sc(12,*)="### ##"<mid(Social_Security_num,"7","4") or just have sc(4,#)= mid(Social_Security_num,"7","4") and hard code the rest on screen.
2. Add an extra real field to the map to hold the numeric value wanted.  In this case you will have to run a process to update this field and modify your input program to post to this field.
3. Since you haven't advised which version of filePro you are using, if you have a version which can encrypt the value, I would suggest using #2.

filePro does not offer a "mask" option but one can handle this within processing.

Hope this helps.


Richard Kreiss
GCC Consulting





-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 13814 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170823/18d9f70f/attachment.bin>