ValuesLessThanOrEqual ( list ; reference)
Rate this function: Average rating: 3.8 (10 votes) Discuss this Custom Function
Jeremy Bante, OshVay Systems, Inc.
http://www.oshvay.com
ValuesLessThanOrEqual( list; reference) returns all values in list that are less than or equal to reference; it's used by QuickSort( list).
Sample Input:
ValuesLessThanOrEqual(
"Tye
Mineko
Leia
Giang
Promise
Helen
Leilani
Megan
Alix
Leslie
Heather
Laura
Emilie
Wen-Lian
Marisa
Tricia
Hana
Arianna"; "Leia
") |
|
Sample Output:
Giang
Helen
Alix
Heather
Laura
Emilie
Hana
Arianna
|
|
Description:
ValuesLessThanOrEqual( list; reference) returns a list of all values in list that are less than or equal to reference by comparing the first value; then concatenating all other values less than or equal to reference with a recursive call to itself.
ValuesLessThanOrEqual() is used by QuickSort( list) to separate out values that are less than or equal to a particular "pivot" value.
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:
|
Newest Custom Functions:
| 1. |
list.intersect (listA; listB) |
| |
(Mon, May 14, 12:43pm) |
| 2. |
WeekStart ( weekOfYear ; year ) |
| |
(Sat, May 12, 8:42am) |
| 3. |
PercentToWords (FIELD) |
| |
(Thu, May 10, 3:16pm) |
| 4. |
PercentToText (FIELD) |
| |
(Thu, May 10, 2:37pm) |
| 5. |
StripReserved( text ) |
| |
(Wed, May 02, 6:05pm) |
| 6. |
ListBaseTables |
| |
(Wed, May 02, 3:48pm) |
| 7. |
ValidEmail( theEmail ) |
| |
(Wed, May 02, 7:27am) |
| 8. |
UltraDate (Text; LongDate_or_DateDigit) |
| |
(Wed, May 02, 6:07am) |
 |
|
The equals part isn't quite working. For example, with the following you only get "friday". If you add a blank space after the reference such as "mon " then it also matches "mon".
ValuesLessThanOrEqual ( "mon¶monday¶friday¶saturday" ; "mon" )
Bill Doerrfeld, Seattle
October 19, 2009 4:44pm