i found below string fucntion. in help document but it will check [A-Za-z] pattern.
string matches(string srcRegex, string srcStr [, string caseInsensitive=false])
Solved
Is there an expression to verify that a list of EMPNAME contains only characters in Ataccama one web 13.6 version ? like REG_MATCH(column,[a-zA-Z])
- Data Pioneer
Best answer by MayKwok
In ONE web 13.6, you can use this in condition builder
You can modify this regex to whatever regex you want.
In a non-regex way, I also sometimes use trashNonLetters(ATTRIBUTE_1)<>ATTRIBUTE_1 . If both sides equal it means there were no non-letters trashed, meaning ATTRIBUTE_1 only has letters.
Does this help?
- Data Pioneer L2
- 16 replies
- Answer
In ONE web 13.6, you can use this in condition builder
You can modify this regex to whatever regex you want.
In a non-regex way, I also sometimes use trashNonLetters(ATTRIBUTE_1)<>ATTRIBUTE_1 . If both sides equal it means there were no non-letters trashed, meaning ATTRIBUTE_1 only has letters.
Does this help?
- Data Pioneer
- 6 replies
Thanks for your response and i tried in both ways but it not working .
let me show the input value like “WinTer cOMing”.
i tried with 1 and 2 ways but it is not doing string check.
- trashNonLetters(TRIM(UPPER(ATTRIBUTE_1)))<>TRIM(UPPER(ATTRIBUTE_1))
2)(matches("[^ \f\n\r\t\wa-fA-F ]", UPPER(trim(ATTRIBUTE_1))))
the result is not working .
Reply
Most Liked this week
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.