Functions: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 15: | Line 15: | ||
Takes a range of values, and concatenates them together with a separator | Takes a range of values, and concatenates them together with a separator | ||
*'''Parameters''': | *'''Parameters''': | ||
== Headline text == | |||
Revision as of 23:11, 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: