How to Use the MIDB Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide covers 3 topics for using MIDB, including creating a formula field, entering parameters, and checking example results; 3 items are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call MIDBFree
22. Enter the MIDB parameter formatFree
33. Use an example formula and review the resultFree

How-to Guide

1. Create a formula field and call MIDB

Entry path: Add Field → Formula

  1. Open the multidimensional table where you want to process data.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes MIDB in the formula editor.
  5. Click Confirm to save the field.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • What you can do next: You can continue editing or replacing the formula in that field.
  • No side effect: Existing source fields remain unchanged.

Tips While Using

  • Common mistake: Using a plain text field instead of a formula field.
  • Environment note: You need permission to edit fields in the current multidimensional table.

2. Enter the MIDB parameter format

Entry path: Formula editor → Function input area

  1. Type MIDB( in the formula editor.
  2. Enter the target text, starting position, and extraction byte length in order.
  3. Check commas, parentheses, and field references carefully.
  4. Adjust the parameters based on the actual record content.
  5. Save the formula and review the returned result.

Success Criteria

  • Interface result: The formula editor recognizes MIDB syntax normally.
  • What you can do next: After saving, the field returns an extracted result.

Tips While Using

  • Common mistake: Entering an incorrect starting position or extraction length, which can return an empty or unexpected result.
  • Environment note: Double-byte and single-byte text can produce different outcomes, so it helps to test with sample records first.

3. Use an example formula and review the result

Entry path: Formula field → Result preview

  1. Enter a MIDB example formula in the formula field.
  2. Save the field and review the returned value for the current record.
  3. Change the source field content and check whether the formula result updates.
  4. If needed, combine MIDB with other functions for more complex processing.

Success Criteria

  • Interface result: The field shows a readable extracted result.
  • What you can do next: When source data changes, the result refreshes automatically.

Tips While Using

  • Common mistake: Entering only the function name without completing the parameters.
  • Environment note: If a referenced field is empty, the result may also be empty or different from what you expect.