Reltio Connect

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.

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.

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.

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,

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.

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.

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

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,

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.

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.