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])

  • 22 September 2022
  • 2 replies
  • 78 views
M
Userlevel 2
Badge +1

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]) 

icon

Best answer by MayKwok 22 September 2022, 13:06

View original

2 replies

M
Userlevel 5
Badge +4

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? 

M
Userlevel 2
Badge +1

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.

  1. 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


Community Terms of Use & ConditionsCookie settings