mid
|
The mid function returns a specified number of characters from a Text or String
argument, with a specified length and starting at a specified character.
Usage The mid function is used to create a substring of a specified length
{length} starting from a specified starting position {start}.
(mid string start length) The substring of length {length} starting from the middle
character of the String or Text.
Expression:
Arguments
Name
Type
Description Argument: string String or Text
The Text or String containing the character(s) you want to extract. Argument: start Integer
Any positive integer representing the position of the first
character you want to extract from text. That is, to begin with the
first character in the text, set start to zero, for the second
character, set it equal to one and so on.
If start is greater than the length of text, mid returns the
empty string "".
If start is less than the length of text, but exceeds the length
of text, mid returns the characters from start to the end of the
Text or String.
If start is less than 0, mid returns an error code. Argument: length Integer
Specifies how many characters to return from Text.
If length is negative, mid returns an error code.
Returns:
Here are a number of links to Lambda coding examples which contain this instruction in various use cases.
Here are the links to the data types of the function arguments.
String | Text | Integer |
Here are also a number of links to functions having arguments with any of these data types.
Analytic Information Server (AIS)AIS Component Systems
|