Functions: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Ordinal(n): Given an integer, returns a string with that number, and the ordinal of that number. *Parameter: n As Integer *Example: =Ordinal(3) *Returns: 3rd =ExtractElement(str...") |
No edit summary |
||
| Line 1: | Line 1: | ||
==ExtractElement(str,n,sep)== | |||
*Parameter: n As Integer | Returns the nth element from a string, using a specified separator character | ||
*Example: = | *'''Parameter''': str as String, n As Integer, sep as String | ||
*Returns: | *'''Example''': =ExtractElement("Monkey&Apes&Chimps",2,"&") | ||
*'''Returns''': Apes | |||
= | ==Ordinal(n)== | ||
*Parameter: | Given an integer, returns a string with that number, and the ordinal of that number. | ||
*Example: = | *'''Parameter''': n As Integer | ||
*Returns: | *'''Example''': =Ordinal(3) | ||
*'''Returns''': 3rd | |||
Revision as of 22:07, 11 July 2012
ExtractElement(str,n,sep)
Returns the nth element from a string, using a specified separator character
- Parameter: str as String, n As Integer, sep as String
- Example: =ExtractElement("Monkey&Apes&Chimps",2,"&")
- Returns: Apes
Ordinal(n)
Given an integer, returns a string with that number, and the ordinal of that number.
- Parameter: n As Integer
- Example: =Ordinal(3)
- Returns: 3rd