OriginalToNatural ( value ; cont )
Converts values to "natural" values
Average rating: 5.0 (1 vote) Log in to vote
Ángel Martínez Fernández - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Natural sort order is an ordering of strings in alphabetical order, except that multi-digit numbers are ordered as a single character. Natural sort order has been promoted as being more human-friendly ("natural") than the machine-oriented pure alphabetical order.
For example, in alphabetical sorting "z11" would be sorted before "z2" because "1" is sorted as smaller than "2", while in natural sorting "z2" is sorted before "z11" because "2" is sorted as smaller than "11".
That's why I called it "natural" values
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.