Reltio Connect

 View Only
  • 1.  Advanced Name cleansers

    Posted 06-24-2024 13:21

    Hey community,

    We don't want to use Java for building custom cleansing function, does any one have similar situation or aware of process for have a name cleanser functions for the names like below.

    Names: 

    Sue-Ann O'Leary, 

    Anna-Lee O'Connell,

    Sue-Ann O'Keefe

    Thanks,

    Venu



    ------------------------------
    venu podila
    360Insights
    ------------------------------


  • 2.  RE: Advanced Name cleansers

    Reltio Employee
    Posted 06-25-2024 12:07

    Hi Venu,

    When you say cleansing function, can you please elaborate?  Exactly what cleansing are you looking to have done to those names?  i.e. are those names inputs or outputs of the cleanser?



    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 3.  RE: Advanced Name cleansers

    Posted 06-25-2024 13:00

    Hi Gino,

    I was looking for a name cleansing function. Those are the Inputs which we are receiving and should process like same.

    example: 

    we should accept the names which looks like Sue-Ann O'Leary, name cleansing should be applied to SuE-AnA o'leARY to look like Sue-Ann O'Leary



    ------------------------------
    venu podila
    360Insights
    ------------------------------



  • 4.  RE: Advanced Name cleansers

    Reltio Employee
    Posted 06-25-2024 13:21
    Interesting!  I think that's going to take a regular expression but its beyond my skills to tell you what that regex would look like.

    There are two ways that I can think of to execute that.  One is with the S3 file cleanser https://docs.reltio.com/en/model/cleanse-data/cleanse-and-standardize-data-overview/out-of-the-box-cleanse-functions/s3-file-cleanser.  The other is to execute the regex after the fact with an RIH (Or other integration tool) recipe.

    --

    Gino Fortunato

    Senior Sales Engineer

    gino.fortunato@reltio.com
    +1.415.867.4195
    blog.reltio.com
    Get the Study
    Total Economic Impact Study Finds Reltio's Modern MDM Delivered 366% ROI