December 8, 201015 yr 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!
December 8, 201015 yr 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.
Create an account or sign in to comment