Difference between revisions of "Manuals/calci/MIDB"
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MIDB'''(Text, Start_num, Number_chars) where, '''Text''' - is the text string to extract. '''Start_nu...") |
(No difference)
|
Revision as of 21:40, 24 October 2013
MIDB(Text, Start_num, Number_chars)
where,
Text - is the text string to extract.
Start_num - is the position of the first characters.
Number_chars - represents the number of charcaters you want MID to extract.
MIDB returns a spcific number of characters from a text string, based on the number of bytes you specify. MIDB is intended for use with languages that use the double-byte character set (DBCS).
If Start_char < 1, MIDB returns #ERROR.
If Number_chars < 0, it returns #ERROR.
If Start_char > Lengthof Text, It returns all text.
If Start_char or Number_chars omitted, it returns all text
MIDB
Lets see an example in (Column1, Row2)
=MIDB(R1C1,2,6)
MIDB returns OHN S.
Lets see an another example in (Column1,Row4)
=MIDB(R1C1)
MIDB returns JOHN SMITH.
Consider an example in (Column1, Row3)
=MIDB(R1C1,2)
MIDB returns JOHN SMITH.
Column1 | Column2 | Column3 | Column4 | |
Row1 | JOHN SMITH | |||
Row2 | OHN S | |||
Row3 | JOHN SMITH | |||
Row4 | JOHN SMITH | |||
Row5 | ||||
Row6 |
TABLE3 | File:Calci1.gif | $ |