Manuals/calci/MID
MID(txt,snum,noc)
where txt is the text string containing the characters that want to extract and snum is the position of the first character that want to extract in text and noc is the number of characters.
MID calculates a specific number of characters from a text string, starting at the position that specify, based on the number of characters that specify.
Note MID works with languages that use the single-byte character set (SBCS),
When snum is greater than the length of text, MID displays 0.
MID displays 0 ,when snum is less than the length of text, but snum plus noc exceeds the length of text.
MID displays 0 when snum is less than 1.
When noc is negative, MID displays 0.
MID
let’s see an example in (Column1 Row 1)
Column1Row1 = Thermal Energy
=MID(C1R1,9,14) is Energy
[javascript:ToggleDiv('divExpCollAsst_4') ///rly =MID(C1R1,2,4) is her]
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Thermal Energy | Energy | her | |
| Row2 | 0 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
