Skip to main content
Solved

Advance Filter functions - Length of characters

  • August 28, 2024
  • 3 replies
  • 57 views

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
 

 

3 replies

  • Author
  • Data Voyager
  • August 28, 2024

 


Forum|alt.badge.img+2
  • Ataccamer
  • 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
  • August 28, 2024

Brilliant thank you