All Implemented Interfaces:
PostfixMathCommandI, Serializable

public class Mid extends NaryFunction
Extract substring of first argument: mid("abcdefg",2,3) -> "cde" Syntax: mid(str,start,len) Second argument is starting index, with the first character being at index 0. Third argument is number of characters to return. Note this differs from Excel's mid function which has 1 as the index of the first character.
  • If start is greater than the length of the string an EvaluationException is thrown.
  • If start is less than zero an EvaluationException is thrown.
  • If len is less than zero an EvaluationException is thrown.
  • If start+len is greater than the length of the string return all characters from start.
  • If str is not a string an EvaluationException is thrown.
  • If start is not a number representing an integer an EvaluationException is thrown.
  • If end is not a number representing an integer an EvaluationException is thrown.
See Also: