Export (0) Print
Expand All
Expand Minimize

2.1.1019 Part 4 Section 3.17.7.208, MID

a. The standard states that MID is intended for use with languages that use the single-byte character set (SBCS), whereas MIDB is intended for use with languages that use the double-byte character set (DBCS).

In Office, MID is intended for use with any language, whereas MIDB is intended for use with languages that use the double-byte character set (DBCS).

b. The standard states if start-pos < 0, #VALUE! is returned.

Office returns #VALUE! if start-pos < 1.

c. The standard states that if the start-pos argument is greater than the length of string, or if start-pos and number- bytes combined exceeds the length of the string argument, the whole of the string argument shall be extracted.

In Office, if start-pos is greater than the length of string the empty string is returned. If start-pos and number-bytes combined exceeds the length of string, the remainder of string starting at byte position start-pos is returned.

Show:
© 2014 Microsoft