Difference between revisions of "Manuals/calci/MIDB"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=MIDB(txt, snum, nob)= | =MIDB(txt, snum, nob)= | ||
| − | + | <div style="font-size:30px">'''MIDB (Text,Start_Char,Num_Char) '''</div><br/> | |
where, | where, | ||
| − | *<math> | + | *<math>Text</math> is a text string containing the characters to be extracted, |
| − | *<math> | + | *<math>Start-Char</math> is the starting position of the first character to be extracted, and |
| − | *<math> | + | *<math>Num-Char</math> represents the number of characters to be displayed in bytes. |
| − | + | **MIDB(), returns a specific number of characters from a text string starting at the position you specify.MIDB is intended for use with languages that use the double-byte character set (DBCS). | |
| − | MIDB() | ||
== Description == | == Description == | ||
| − | MIDB( | + | MIDB (Text,Start_Char,Num_Char) |
| − | |||
e.g. MIDB("<#*>",1,2) displays '''<#''' as a result. | e.g. MIDB("<#*>",1,2) displays '''<#''' as a result. | ||
*MIDB works with the languages that use 'Double Byte Character Set' (DBCS). | *MIDB works with the languages that use 'Double Byte Character Set' (DBCS). | ||
*MIDB counts each double byte character as 2, when language is set to DBCS. Else it counts 1 byte per character. | *MIDB counts each double byte character as 2, when language is set to DBCS. Else it counts 1 byte per character. | ||
| − | *If argument <math> | + | *If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name"). |
| − | *<math> | + | *<math>Start-Char</math> should be > 1, else Calci displays #N/A error message. |
| − | *If <math> | + | *If <math>Start-Char</math> > 'length of text', Calci displays empty text (""). |
| − | *If <math> | + | *If <math>Start-Char</math> + <math>Num_Char</math> > 'length of text', Calci displays the characters up to the end of text. |
| − | *If <math> | + | *If <math>Num_Char</math> is negative, Calci displays an #N/A error message. |
== Examples == | == Examples == | ||
Revision as of 15:21, 13 August 2018
MIDB(txt, snum, nob)
MIDB (Text,Start_Char,Num_Char)
where,
- is a text string containing the characters to be extracted,
- is the starting position of the first character to be extracted, and
- represents the number of characters to be displayed in bytes.
- MIDB(), returns a specific number of characters from a text string starting at the position you specify.MIDB is intended for use with languages that use the double-byte character set (DBCS).
is a text string containing the characters to be extracted,
is the starting position of the first character to be extracted, and
represents the number of characters to be displayed in bytes.
Description
MIDB (Text,Start_Char,Num_Char) e.g. MIDB("<#*>",1,2) displays <# as a result.
- MIDB works with the languages that use 'Double Byte Character Set' (DBCS).
- MIDB counts each double byte character as 2, when language is set to DBCS. Else it counts 1 byte per character.
- If argument is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
- should be > 1, else Calci displays #N/A error message.
- If > 'length of text', Calci displays empty text ("").
- If + > 'length of text', Calci displays the characters up to the end of text.
- If is negative, Calci displays an #N/A error message.
> 'length of text', Calci displays the characters up to the end of text.Examples
| ABC DEF | ||
| *123*123 | ||
=MIDB(A1,1,5) : Displays 5 character string in cell A1 starting from 1st position.
Displays ABC D as the output. Space character is also included. =MIDB(A2,1,1) : Displays 1 character string in cell A3 starting from 1st position.
Displays * as the output.
Need to give examples with characters/language supporting DBCS
Related Videos
See Also
References