Skip to main content

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

 


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
 

 


Brilliant thank you


Reply