Reltio Connect

 View Only
  • 1.  Validation Functions - Strings

    Posted 08-19-2021 06:07
    Hi Mates,

    Hope you all are doing good !!

    I am facing issue to display validation message post configuring the validation functions.
    Scenario - I have a field "Website" where i need to add a validation function - if anyone enters their email id in place of Website i should display a message.

    Column Name - Website

    Case 1 - 
    Value - google.com
    Validation function - N / A

    Case 2 - 
    Value - xyz@gmail.com
    Validation function - Since @ is used, please check the data.

    i have tried the below as well, but it doesn't seem working.



  • 2.  RE: Validation Functions - Strings

    Reltio Employee
    Posted 08-23-2021 08:09
    @Chetan P, I haven't forgotten about this one. I am looking for an answer now.

    Chris ​


  • 3.  RE: Validation Functions - Strings

    Reltio Employee
    Posted 08-23-2021 09:28
    Hello Chetan,

    Instead of "Contains" try using "regular expression match" operator with the regex "^[a-zA-Z0-9+_.-]+@[a-zA-Z0-9.-]+$". Please see the screenshot below.
    Thanks,
    Prasad