Functions: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
*'''Example''': =Ordinal(3) | *'''Example''': =Ordinal(3) | ||
*'''Returns''': 3rd | *'''Returns''': 3rd | ||
==ConcatenateStrings (range,column,filter,filter column,separator) | |||
Takes a range of values, and concatenates them together with a separator | |||
*'''Parameters''': | |||
Revision as of 23:10, 25 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
==ConcatenateStrings (range,column,filter,filter column,separator)
Takes a range of values, and concatenates them together with a separator
- Parameters: