MID() Function

YouTube: How to Use the MID ( ) Function in Report Custom Columns?

How to Use the MID ( ) Function in Report Custom Columns?

In this tutorial, you’ll learn how to use the MID function in expressions to extract a specific portion of text from a string. We'll apply this logic both in the data grid and within a report layout in Logic ERP.

Accessing the Expression Designer:

• Open Sale Voucher or any document.

• Navigate to the "Setup Column Attributes".

• Here, you'll see a list of available columns that can be used to build expressions.

• Click on "Add/Edit Expression Columns" where you can write your expression using predefined functions.

Writing Your First Expression

• Every expression must start with the script header: '#@LSCRIPT

• Click the (+) Plus icon to create a new expression.

• Fill in the required fields:

  • Expression Name – A unique name for your expression.

  • Expression Type – Choose either Text or Numeric depending on the expected output.

Creating a Simple MID() Expression

• Double-click your newly created expression to insert it into the script editor.

• Define the expression using the syntax:

  • Expression Name = MID("ITEM_NAME", 1, 5)

  • "Item Name" is the source field.

  • 1 is the starting position (first character).

  • 5 is the number of characters to extract.

• Click Save to apply.

• Scroll down and check the box to enable this expression in the data grid.

• Save and proceed to check the effect.

• The grid will now display a column with the first 5 characters of each Item Name.

Applying the Expression in a Report

• Navigate to the Reporting section.

• Open the Sales Register Detailed Report or any "Report".

• Go to Setup Column Attributes as you did earlier.

• Before adding the expression to the report, go to Other Settings.

• Ensure the Script Editor is set to VBScript.

• Click Save.

  • Note: VBScript is the default for new configurations but always verify this setting.

Adding and Using the Expression in the Report

• Return to "Setup Column Attribute" window.

• Click "Add/Edit Expression Columns".

• Every expression must start with the script header '#@LSCRIPT

• Click the (+) Plus icon to create a new expression.

• Fill in the required fields:

  • Expression Name – A unique name for your expression.

  • Expression Type – Choose either Text or Numeric depending on the expected output.

• Double-click your newly created expression to insert it into the script editor.

• Define the expression using the syntax:

  • Expression Name = MID("ITEM_NAME", 1, 5)

  • "Item Name" is the source field.

  • 1 is the starting position (first character).

  • 5 is the number of characters to extract.

• Click Save.

• Scroll down and check the box to enable the column in the report.

• Save and proceed to check the effect.

• Refresh the report to view the final result.

• You will now see the first 5 characters of the Item Name displayed in the new expression column.