AnsweredAssumed Answered

Function Masking with condition IF

Question asked by Nieves on Jul 6, 2017
Latest reply on Jul 6, 2017 by dovle01

Hi,


We need to mask fields from conditions specified by us.

For example, the phone will be masked according to the following conditions. And we would need it to be reusable for all our projects regardless of the connection.

 

IF ((SUBSTR(TELEPHONE,1,1) ='6') OR (SUBSTR(TELEPHONE, 1,1) ='7')) THEN

      TELEPHONE='666555666';

ELSE

       IF ((SUBSTR(TELEPHONE,1,1) ='+') AND ((SUBSTR(TELEPHONE, 4,1) ='6') OR (SUBSTR(TELEPHONE, 4,1) ='7'))) THEN

             TELEPHONE='+34666555666';

       ELSE

              IF (SUBSTR(TELEPHONE,1,1) ='+') THEN

                   TELEPHONE='+34937280000';

             ELSE

                    TELEPHONE='937280000';

             END IF;

       END IF;

 END IF;

 

How can we do it with Fast Data Masker?

 

Thanks and regards.

Outcomes