Reltio Connect

 View Only
  • 1.  DVF regex - identify leading and trailing spaces

    Reltio Partner
    Posted 11-23-2022 11:22
    Hi,

    applied below regex to identify the leading and trailing spaces in DVF:
    Regex Expression: regexp(attributes.Name.value, '\\s+$') or regexp(attributes.Name.value, '^\\s+')
    But not able to catch those blank spaces. 
    Although above mentioned regex is working fine java8, but not working in Reltio -DVF.
    can someone from this community suggest me some resolution.

    ------------------------------
    Pradipta Chakraborty
    Cognizant Technology Solution (P) India Limited
    ------------------------------


  • 2.  RE: DVF regex - identify leading and trailing spaces

    Reltio Employee
    Posted 11-27-2022 23:45
    i'm assuming you want to identify them so you can get rid of them. 

    The string cleanser will remove them with the 'trim' option.  Documentation is at https://docs.reltio.com/en/model/cleanse-data/cleanse-and-standardize-data-overview/out-of-the-box-cleanse-functions/string-cleanser

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