Skip to main content
Solved

Advance Filter functions - Length of characters


Hi there

 

Was wondering how I can use the length function in the Advanced Filtering to filter instance records where they either are under or over a certain length of characters.

 

ie ‘instance record’ LENGTH >= 8 characters

Best answer by AKislyakov

Hi @mauriceK,

The syntax of Advanced search conditions is described in Searching for Data :: Ataccama ONE. Also, you can click on the Help button below the search box.
As for your question, length is a function, so you need to use it like length(<FIELD>) >= 8
 

 

View original
Did this topic help you find an answer to your question?

3 replies

  • Author
  • Data Voyager
  • 5 replies
  • August 28, 2024

 


Forum|alt.badge.img+2
  • Ataccamer
  • 146 replies
  • Answer
  • August 28, 2024

Hi @mauriceK,

The syntax of Advanced search conditions is described in Searching for Data :: Ataccama ONE. Also, you can click on the Help button below the search box.
As for your question, length is a function, so you need to use it like length(<FIELD>) >= 8
 

 


  • Author
  • Data Voyager
  • 5 replies
  • August 28, 2024

Brilliant thank you


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings