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 spacesNotExpected - Symbols, special charactersTried few functions but those are not working as expected. Any help here.
Hi Chetan,Can you try below regular expression:[^a-z^A-Z^0-9^ ]+
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.
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.
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
This inputs helps Sheshadri. Thanks for this.!
100 Marine Pkwy #275, Redwood City, CA 94065
+1 (855) 360-DATA+1 (855) 360-3282
© 2022 Reltio. All Rights Reserved
Site by eConverse MediaAlso of Interest: Master Data Management (MDM) Reltio Community Reltio Integration Hub Community, Data Management Community Matching, Merge, Survivorship Reltio Workflow Master Data Management (MDM)