Identifying A Range Of Numbers Within A Case Statement

[davidnickerson]

I'm interested in writing the simplest expression that looks for a range of numbers within a field.

Example: Is the number of characters in (text) between 6 and 10?

I can certainly do this with multiple Length calls:

Case ( Length ( text ) < 10 and Length ( text ) > 6 ; "yep"; "nope" )

However, I'm thinking FM should have a more elegant way to determine a range of values here. I.E., field definitions support the "in range" concept, find requests allow for "7...9", etc. How can I obtain a range in a calc without concatenating 2 or more statements?

Thanks in advance!

[databaser]

I'm interested in writing the simplest expression that looks for a range of numbers within a field.

Example: Is the number of characters in (text) between 6 and 10?

I can certainly do this with multiple Length calls:

Case ( Length ( text ) < 10 and Length ( text ) > 6 ; "yep"; "nope" )

However, I'm thinking FM should have a more elegant way to determine a range of values here. I.E., field definitions support the "in range" concept, find requests allow for "7...9", etc. How can I obtain a range in a calc without concatenating 2 or more statements?

Thanks in advance!

I don't think you can, but I think the way it allows you to do it is just fine.