Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

  • 1.  I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-15-2019 06:16:00 AM
    I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by 0 and rest of the value should not be mask.


    Kindly please help to achieve this scenario.
    #Masking


  • 2.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-15-2019 09:00:00 AM

    Hi Ashok,

    You can user segmented mapping algorithm to achieve the need, where you can split the value to a bunch of segments and treat them as you like.

    You can apply the desired rang of masked values and also preserve some if you like.

    Please check this KB note from delphix support for more detail (you will find an example)


    https://support.delphix.com/Delphix_Masking_Engine/KBA1775_Segment_Mapping_(SM)_Technical_Overview

    If you steel need help please revert to me back i will be glad.

    Regards,

    Mouhssine



  • 3.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-25-2019 06:21:00 AM
    Thank you for your help.

    Can you please send me one example to replace only 8th character with o.


    Thanks,
    Ashok Kumar


  • 4.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-16-2020 05:01:00 AM
    Hello,
    I am able to replace 4th & 5th character with some other Values, But not able to  replace 8th character with 0.
    I have tried different combinations to replace 8th character with 0. But not able to find the solution. 
    Can you please help me to resolve this?

    ex:
    Source Value: BNMKNK8236 
    Mask Value:    BNMKLM8036

    Thanks,
    Ashok Kumar.

    ------------------------------
    Ashok Kumar
    Community Member
    Delphix Community Members
    ------------------------------

    Original Message


  • 5.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-18-2020 01:08:00 PM
    Ashok,
    When defining your 8th character in your segmented mapping algorithm, did you try to make use of the mask values boxes ?   Try putting a 0 in the Range #  box under the masked values.  Leave the real values emtpy.  This should change any input character (real value)  into the mask value (0) to what you specify in the range # box.​​

    ------------------------------
    Suzanne Lusardi
    IT DB Governance & Compliance Analyst
    Paychex, Inc.
    ------------------------------

    Original Message


  • 6.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-19-2020 01:59:00 AM
    Hi suzanne,
    Thanks for your email.

    I have tried same configuration what you explined above. But i am not getting 0 at 8th position. 

    Created segment mapping with below configuratioin:

    1/3 segments of 4 alphanumeric values each 
    2/ On segment 2 :
    for the 4 field set range as 0
    3/ On the preserve section of the algorithm :
    start position 1 length 4
    start position 7 length 1
    start position 9 length 3

    Below is the sample source and masked data.
    Source data:
    BICCODE NUM LOC
    ABNAUS49FXZ 2791 CHN
    SWEDHK60NLX 5717 DLH
    AKMLMD48FPZ 5611 MUM

    Mask data:
    BICCODE NUM LOC
    ABNAMW42FXZ 2791 CHN
    SWEDCR67NLX 5717 DLH
    AKMLXH45FPZ 5611 MUM

    Best Regards,
    Ashok.

    ------------------------------
    Ashok Kumar Athuluri
    Associate Engineer
    BNP Paribas - Asia
    ------------------------------

    Original Message


  • 7.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'
    Best Answer

    Posted 02-19-2020 02:33:00 AM
    Hi Ashok,

    I have no access for the moment to a delphix engine to test it for you, but here is a plan that i want you to test.

    Nota, remember, you have always to not count the segment(s) you want to preserve when creating a segment mapping.

    To mask ABNAUS49FXZ => ABNAMW40FXZ please try the following

    1/1 segments of 2 (this is the default for the first created segment) alphanumeric values each 
    2/ For the 2 field for this segment set range as 0
    3/ On the preserve section of the algorithm :
    start position 1 length 4
    start position 7 length 1
    start position 9 length 3

    Regards,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------

    Original Message


  • 8.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-19-2020 09:29:00 AM
    Thank you Mouhssine. It is working for above scenarion.

    If I want to replace only 8th character with 0 and preserve remaining all characters same as source data?

    ------------------------------
    Ashok Kumar Athuluri
    Associate Engineer
    BNP Paribas - Asia
    ------------------------------

    Original Message


  • 9.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-19-2020 09:52:00 AM

    Hi Ashok,

    Sorry didn't get the point right. Can you please provide a simple of what should look like source and target data you need after masking.

    Regards,

    Mouhssine



    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------

    Original Message


  • 10.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-20-2020 06:06:00 AM
    Hi,
    Requirement is to set only 8th character to 0 and remaining we want same as Source data.

    Example: 
    Source Data
    BICCODE
    ABNAUS4UFXO
    SWEDHK69NLR
     
    Masked Data
    BICCODE
    ABNAUS40FXO
    SWEDHK60NLR


    ------------------------------
    Ashok Kumar Athuluri
    Associate Engineer
    BNP Paribas - Asia
    ------------------------------

    Original Message


  • 11.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-20-2020 06:13:00 AM
    Hi Ashok,

    This will be good to achieve the need

    1/1 segments of 2 (this is the default for the first created segment) alphanumeric values each 
    2/ For the 2 field for this segment set range as 0
    3/ On the preserve section of the algorithm :
    start position 1 length 7
    start position 9 length 3


    Regards,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------

    Original Message


  • 12.  RE: I have scenario to mask 4,5 th charecters with some value and 8th charecter shuold be replaced by '0'

    Posted 02-20-2020 06:45:00 AM
    Hello Mouhssine,
    Have tried this before but it is not working for the above scenario. PFB source and Masked data with aboue configuration.

    Source Data Masked Data
    BICCODE BICCODE
    ABNAUS4UFXO ABNAUS4SFXO
    SWEDHK69NLR SWEDHK60NLR
    AKMLMD47FPO AKMLMD44FPO
    DHJUKS74JHL DHJUKS78JHL
    KJUMNH4JFKP KJUMNH4HFKP

    We are not getting 0 at 8th position using the below configuration.
    1/1 segments of 2 (this is the default for the first created segment) alphanumeric values each 
    2/ For the 2 field for this segment set range as 0
    3/ On the preserve section of the algorithm :
    start position 1 length 7
    start position 9 length 3

    ------------------------------
    Ashok Kumar Athuluri
    Associate Engineer
    BNP Paribas - Asia
    ------------------------------

    Original Message