Changes

=MID(txt, snum, noc)=

=MID(txt, snum, noc)=

 

where,  

where,  

*<math>txt</math> is a text string containing the characters to be extracted,

*<math>Text</math> is a text string containing the characters to be extracted,

*<math>snum</math> is the starting position of the first character to be extracted, and

*<math>Start_Char</math> is the starting position of the first character to be extracted, and

*<math>noc</math> represents the number of characters to be displayed.

*<math>Num_Char</math> represents the number of characters to be displayed.

 

**MID(), returns a specific number of characters from a text string starting at the position you specify.

MID() displays a specific number of characters from a text string, with reference to the specified starting position and specified number of characters.

== Description ==

== Description ==

MID(txt, snum, noc)

MID (Text,Start_Char,Num_Char)

 

e.g. MID("String",1,3) displays '''Str''' as a result.

e.g. MID("String",1,3) displays '''Str''' as a result.

*MID counts 1 byte per characters. MID works with the languages that use 'Single Byte Character Set' (SBCS).

*MID counts 1 byte per characters. MID works with the languages that use 'Single Byte Character Set' (SBCS).

*If argument <math>txt</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").

*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").

*<math>snum</math> should be &gt;= 1, else Calci displays #N/A error message.

*<math>Start_Char</math> should be &gt;= 1, else Calci displays #N/A error message.

*If <math>snum</math> &gt; 'length of text', Calci displays empty text ("").

*If <math>Start_Char</math> &gt; 'length of text', Calci displays empty text ("").

*If <math>snum</math> + <math>noc</math> &gt; 'length of text', Calci displays the characters up to the end of text.

*If <math>Start_Char</math> + <math>Num_Char</math> &gt; 'length of text', Calci displays the characters up to the end of text.

*If <math>noc</math> is negative, Calci displays #N/A error message.

*If <math>Num_Char</math> is negative, Calci displays #N/A error message.

== Examples ==

== Examples ==