Hi all, I hit my logical thinking-limit and FileMaker knowledge with the following, seemingly simple problem: I would like to filter a list of values to only show values with four or more words. How can I do that?

Sample Input:

Test

Test Requirement

Test Requirement Example

Test Requirement Example for

Test Requirement Example for HBS

Test Requirement Example for HBS 5.0

Expected Output:

Test Requirement Example for

Test Requirement Example for HBS

Test Requirement Example for HBS 5.0

 

 

Many thanks in advance!

1 hour ago, innodat said:

seemingly simple problem:

I don't think it's that simple. You need to loop over the values and examine each one in turn. Try:

While ( [ 
i = 1 ;
result = ""
] ; 
i ≤ ValueCount ( Input ) ; 
[ 
line = GetValue ( Input ; i ) ;
result = If ( WordCount ( line ) ≥ 4 ; List ( result ; line ) ; result ) ;
i = i + 1
] ; 
result 
)

 

 

What would the FileMaker community do without you?? Seriously. This is amazing. Copy-pasted - works. And I learned something today. 

THANK YOU!!!!!!

Great example for using the new "while" function too.