MIDB in WPS on Windows FAQ

Last updated:July 23, 2026

When using MIDB, common questions usually involve parameter entry, unexpected results, and suitable text scenarios; this FAQ includes 4 common questions and 4 glossary terms.

FAQ

What should I check first if MIDB returns an error?

  1. Check whether the parentheses, commas, and field references are complete.
  2. Confirm that the starting position and extraction byte length are valid values.
  3. If the referenced field content type does not fit the formula, adjust the source data and calculate again.

Can MIDB be combined with other functions?

  1. Enter MIDB in the formula field first.
  2. Use the MIDB result as an argument in another function.
  3. Save the formula and review record results one by one to confirm the logic.

Why does the result change after I edit the source data?

  1. Formula fields calculate based on the current record content.
  2. When the source field value changes, the MIDB result updates as well.
  3. If you need a stable output for later steps, confirm the source field content first.

What kinds of text is MIDB more suitable for?

  1. It is suitable for mixed-language text and double-byte character scenarios.
  2. When character-based extraction does not meet your needs, byte-based extraction is often a better fit.
  3. Before large-scale use, test with sample records first.

Glossary

TermDefinition
MIDBA function that extracts a specified part of text by byte count.
Formula fieldA field type in a multidimensional table that calculates results automatically with a formula.
Double-byte characterA character that usually occupies more bytes in byte-based calculations, common in Chinese, Japanese, and Korean text scenarios.
Starting positionThe parameter that defines where the function begins extracting text.