Structure Formula Column - Only Show Specified Labels

Don Utley

I want to only show certain labels (labels that start with "ABEA") in a structure formula column. So it'd look like these: 

Labels - Filtered Labels

"ABEA_12345, Software, West" - "ABEA_12345"

"ABEA_12345" - "ABEA_12345"

"Software, West" - NULL

 

I thought FILTER is what I need: 

FILTER

FILTER(A, $)

Filters the values in an array and produces a new array that retains only elements for which the user function $ returns a true value (considered as a Boolean).

 

and used: FILTER(labels, "ABEA*") 

but I'm just getting "VALUE!" as a result. 

 

 

EDIT: 

might be one step closer. Tried this: 

label.FILTER( $ = "ABEA*" )

and got blanks. But then I tried a specific value to see if it's the wildcard:

label.FILTER( $ = "ABEA_12345" )

and this worked, but just for ABEA_12345. So it's the wildcard that's messing this up. 

Don Utley

Figured it out using regex and MATCH function. 

label.FILTER( MATCH( $ ,"/^ABEA*/" ) )