Reltio Connect

 View Only
  • 1.  Data Validation function for special character and any number rejection

    Reltio Partner
    Posted 10-14-2022 09:20
    Can someone let me know what would be the regex expression for below requirement:
    the attribute should not contain special characters such as !,@,#,$,%,^,&,*,~,+,|,\,/,<,> or should not contain any Numbers
    or 
    how can I implement this logic in DVF (Data Validation Function)

    have tried with below regex :
    not regexp(attributes.Name.value, '[a-zA-Z-\\s]+$')
    but all the special characters are being rejected for this, 
    tried with below expression also, but DVF not working for this case:
    regexp(attributes.Name.value, '[!@#$%^&*~+|\\/]') or regexp(attributes.Name.value, '[0-9]')
    Can some one please suggest what can be done for it?


  • 2.  RE: Data Validation function for special character and any number rejection

    Reltio Partner
    Posted 10-14-2022 15:00
    Hi Pradipta,

    You can use below condition in the validation function.

    Name   -   Regular Expression does not match   -   [a-zA-Z-\s}+$

    Query Builder: not regexp(attributes.name.value, '[a-zA-Z-\\s]+$')

    Result:
    The records which has special characters excluding - or space will showup
    AAs (or) A-A (or) abc-cf (or) Abd DFR-K   -- These records will treat as good records because it has either space or - in the firstname
    AA9 (or) ?est (or) K=L (or) A! (or) Tes]   -- DVF shows as Warning since these records having special characters other than space -


  • 3.  RE: Data Validation function for special character and any number rejection

    Reltio Partner
    Posted 10-14-2022 15:42
    Create DVF and use below condition.

    not regexp(attributes.Name.value, '[a-zA-Z-\\s]+$')

    Validation function returns the profiles which are having special characters in Name attribute other than Characters, hyphon, space.

    [THE ABOVE MESSAGE DID NOT SHOW-UP AFTER COUPLE OF MINUTES, HENCE POSTED THIS MESSAGE, PLEASE IGNORE THIS MESSAGE]