Reltio Connect

 View Only
  • 1.  Validation function Attribute Value | Brainstorming

    Posted 21 days ago

    Hi Team,

    Was looking over a solution for creating validation rules (Regex function).

    Scenario : Validation rules to throw warning if any special character is present.

    Expected - It should allow alphabets (case in-sensitive), numbers and spaces
    NotExpected - Symbols, special characters

    Tried few functions but those are not working as expected. Any help here.




    ------------------------------
    Chetan P
    Senior MDM Specialist
    Freshworks
    Chennai
    ------------------------------


  • 2.  RE: Validation function Attribute Value | Brainstorming

    Reltio Partner
    Posted 19 days ago

    Hi Chetan,

    Can you try below regular expression:
    [^a-z^A-Z^0-9^ ]+

    Sample

    You can try this website: https://regex101.com/
    And here the flavor should be Java8 as Reltio only supports Java 8. Also you can find explanation on the right and matches just below that.
    Please try out and update.




    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------



  • 3.  RE: Validation function Attribute Value | Brainstorming

    Posted 17 days ago

    Thanks @Sheshadri V for the response.
    Through  https://regex101.com/ i am able to validate, but it is not working as expected when i try the same through Reltio. Just checking on this on what is the issue.



    ------------------------------
    Chetan P
    Senior MDM Specialist
    Freshworks
    Chennai
    ------------------------------



  • 4.  RE: Validation function Attribute Value | Brainstorming
    Best Answer

    Reltio Partner
    Posted 17 days ago

    Hi Chetan,

    You may have to escape some of the special characters in the expression:
    you can check this link: https://www.abareplace.com/blog/escape-regexp/
    Also check this link to provide backslashes: https://docs.reltio.com/en/model/cleanse-data/validate-cleansed-data/data-validation-function



    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------



  • 5.  RE: Validation function Attribute Value | Brainstorming

    Posted 17 days ago

    This inputs helps Sheshadri. 

    Thanks for this.!



    ------------------------------
    Chetan P
    Senior MDM Specialist
    Freshworks
    Chennai
    ------------------------------