FILEMAKER: IsNumberInRange By Ibrahim Bittar Torres, Eikonsys

© 2010 Dwayne Wright - dwaynewright.com

From Dwayne Wright PMP - Certified FileMaker 10, 9 & 8 Developer
EMAIL: info@dwaynewright.com     TWITTER: dwaynewright

CHAPTER 20: Custom Functions

IsNumberInRange By Ibrahim Bittar Torres, Eikonsys
IsNumberInRange ( Number , LowerLimit , HigherLimit )
Determines if a given number falls between two reference numbers.
http://www.briandunning.com/cf/604

Wanted to pass along this link to a custom function I used today. I was doing a common parsing task for a customer. Given a large block of text, I was examining it line by line and putting significant data from the block into key fields. On one line, I needed to know if the last word was a number or not. If it was a number, I needed to populate a field named “Level” but leave the field empty if the last word was not a number.

I did a quick search on briandunning.com and it took a few searches to find this one. This isn’t exactly what I was looking for but it was close enough! Check out the link above for the code particulars or to learn more about this functions creator.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2010 - Dwayne Wright - dwaynewright.com