Delphix Products

 View Only
  • 1.  Regarding Free text Redaction Algorithm

    Posted 12-18-2019 06:20:00 AM
    Hi Guys,

    I wanted to mask certain portion of a column having URLs. These urls are acting like a single word(obviously since there are no spaces in a url).
    Free text redaction algorithm is not working on it, Looks like it works only when the given text (to be replaced or masked) is uniquly identified in a text column.
    For text Ex:  'one man Show '
    In this text we can replace "man" with some other word using Free text redaction algo. But if the text is 'onemanshow'
    The Algo is not working since it is not able to identify 'man' as the algo works on a word.

    Can some one suggest me what should i use here as I do not wanted to mask the whole word but only the part of it.


    ------------------------------
    indrajeet yadav
    Technical Test Lead
    Delphix Community Members
    ------------------------------


  • 2.  RE: Regarding Free text Redaction Algorithm

    Posted 12-18-2019 06:45:00 AM
    Hi indrajeet,

    Relay on sql update orader using regexp to replace the word/words in the URL string.

    Regards,

    Mouhssine


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



  • 3.  RE: Regarding Free text Redaction Algorithm
    Best Answer

    Posted 12-18-2019 06:56:00 AM

    Hi,

    To give an idea

    update Table
    set column = REPLACE(column, 'man', 'women') 
    where column like '%man%';

    OR

    update Table
    set column = regexp_replace(column, 'man', 'women')
    Where column like '%man%';


    Regards,

    Mouhssine



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



  • 4.  RE: Regarding Free text Redaction Algorithm

    Posted 12-18-2019 07:10:00 AM
    Thanks Mouhssine, will try this. Looks like pre and Post script queries are very useful when there is no alternative present in the existing algorithms.

    ------------------------------
    indrajeet yadav
    Technical Test Lead
    Delphix Community Members
    ------------------------------



  • 5.  RE: Regarding Free text Redaction Algorithm

    Posted 12-18-2019 07:20:00 AM
    Hi,

    Indeed for some cases it's of a good help.

    For example, in your case you want to change just a portion of the URL and this portion isn't in a fixed place for all URLs like it start at position 3 and end at position 6.

    So you can't use algorithm frameworks to create a convenient algorithm, but you can rely on other workarounds like using sql commands.

    Regards,

    Mouhssine

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