GetParameter( subParameter )
Rate this function: Average rating: 3.1 (20 votes) Discuss this Custom Function
Jeff Drake, Excelisys, Inc.
http://www.excelisys.com
Returns the specified “sub-parameter” of a given script parameter.
Sample Input:
"orderID = 250; " &
"customerName = " & Quote("Jim Smith") & "; " &
"lineItemID = 15690" |
|
Sample Output:
GetParameter("customerName")
-returns-
Jim Smith |
|
Description:
Most methods of defining multiple script parameters require that the developer place the “sub-parameters” in a specific order and then call them by number. By using the Evaluate and Let functions, GetParameter( ) allows you to give each sub-parameter an intuitive name, then call it by name, regardless of where it falls in the full Script Parameter.
Not only is the order of the sub-parameters irrelevant, but so is the number of sub-parameters. If OrderID is the first of five subs in one Script Parameter and the eighth of fifteen in another, the function will work just as well.
Caveat: any sub-parameter that can conceivably be empty must be enclosed in a Quote( ) function. Otherwise, the Let( ) function within GetParameter( ) will fail.
Update: added error trapping for nonexistent subparameters.
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:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
FilteredPortalList ( fieldObjectName ; portalRow ) |
| |
(Tue, May 21, 5:33pm) |
| 2. |
ListToggle ( InList ; InValue ) |
| |
(Thu, May 16, 6:59pm) |
| 3. |
VatFormat ( vat ) |
| |
(Tue, May 14, 2:45am) |
| 4. |
CheckVatBE ( vat ) |
| |
(Tue, May 14, 2:32am) |
| 5. |
CheckIBAN (IBAN ) |
| |
(Tue, May 14, 2:24am) |
| 6. |
OrcidCheckDigit ( Orcid_id ; Result ; Iterations ) |
| |
(Wed, May 08, 1:44am) |
| 7. |
DateRangeBySpan ( Begin ; End ; Term) |
| |
(Mon, May 06, 6:53am) |
| 8. |
Convert_Arabic_to_Chinese( number ) |
| |
(Thu, May 02, 6:10am) |
 |
|