Skip to main content
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])

  • September 21, 2022
  • 2 replies
  • 124 views
M
Data Pioneer
Forum|alt.badge.img+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]) 

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? 

      2 replies

      M
      Data Pioneer L2
      Forum|alt.badge.img+3
      • MayKwokData Pioneer L2
      • Data Pioneer L2
      • Answer
      • September 22, 2022

      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
        Data Pioneer
        Forum|alt.badge.img+1
        • mahesh ArData Pioneer
        • Author
        • Data Pioneer
        • September 23, 2022

        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 .

        Community Terms of Use & ConditionsCookie settingsAccessibility statement