Test Data Manager

Expand all | Collapse all

FORMATLUHN

Jump to Best Answer
  • 1.  FORMATLUHN

    Posted 02-25-2020 02:37 PM
    I just installed 4.9 and would like to use the new FORMATLUHN function, however with the ability to introduce a parameter.

    I am able to exclude characters, however the excluded characters are not part of the Luhn calculation after masking.

    Would it be possible to modify FORMATLUHN to exclude the first character in the masking, but still have it used in the calculation?

    Currently for this value I am running FORMATENCRYPT and then a custom algorithm to ensure the first character is not 0 or 8, and then calculating the last digit to be luhn compliant.

    ------------------------------
    Test Data Management Architect
    Canada Life
    Toronto, ON
    ------------------------------


  • 2.  RE: FORMATLUHN
    Best Answer

    Posted 03-08-2020 03:18 PM
    Please open a support ticket so that we can work with you to get what you want
    Regards, Dahman


  • 3.  RE: FORMATLUHN

    Posted 03-10-2020 02:46 PM
    Will do, thanks!

    ------------------------------
    Test Data Management Architect
    Canada Life
    Toronto, ON
    ------------------------------



  • 4.  RE: FORMATLUHN

    Posted 04-07-2020 04:17 PM
    Thank you very much for the patch!
    It works great.

    This is a much better alternative to mask Canadian SIN numbers with consistency across DBs

    ------------------------------
    Test Data Management Architect
    Canada Life
    Toronto, ON
    ------------------------------