Hi ,
Could someone guide me on creating rules for Name field.
Rule : Name should not have any special characters but can have numbers and spaces.
Ex: Jhon Leo - Valid
Jho1 Leo - Valid
Jho( Leo* - Not Valid
Regards,
Bhuvi
Solved
Creating rules for Name field
- Universe Traveller
Best answer by C_R
Hey Bhuvi, I had a similar requirement before. I solved it by using regex rule that allows only letters, numbers, and spaces while blocking special characters. You can create a DQ rule with this regex: (^[A-Za-z0-9 ]+$) . Hope this helps!
- Data Pioneer
- Answer
Hey Bhuvi, I had a similar requirement before. I solved it by using regex rule that allows only letters, numbers, and spaces while blocking special characters. You can create a DQ rule with this regex: (^[A-Za-z0-9 ]+$) . Hope this helps!
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.