syntax:functions:mid
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
syntax:functions:mid [2015/03/27 17:00] – elenap | syntax:functions:mid [2021/08/16 00:02] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Mid(text, | + | ======Mid(text, |
+ | Category: | ||
- | Returns //K// characters | + | \\ |
+ | =====Description===== | ||
+ | This function returns a substring | ||
- | Note that the expression does not require to use single quote signs (' | + | \\ |
+ | =====Arguments===== | ||
+ | ^Argument^Type^Description^ | ||
+ | |text|Text|Any text value from which the substring of text is returned.| | ||
+ | |start|Number | ||
+ | |length|Number (Integer)|The number of characters to return.| | ||
- | First arguments is implicitly converted into text, if it's not. | + | **Return value type:** Text |
- | ^ Example | + | \\ |
- | | | + | =====Remarks===== |
- | | | + | Number values entered for //text// are implicitly converted to text. |
+ | |||
+ | Entering a value for //start// that is past the number of characters in //text// returns and empty value. | ||
+ | |||
+ | Entering a value for //length// that exceeds the number of characters after the //start// position, returns the text up to the end of //text//. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | mid(' | ||
+ | |||
+ | mid(' | ||
+ | |||
+ | mid(' | ||
+ | |||
+ | mid(123456, 4, 3) //Returns ' | ||
+ | |||
+ | mid(' | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
- | **See also** | ||
- | * [[syntax: | ||
- | * [[syntax: | ||
- | * [[syntax: |
syntax/functions/mid.txt · Last modified: 2021/08/16 00:02 by craigt