mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • General
  • Format Codes
Back to Manual

Format Codes

 

Defined edit codes are stored in a text file /mrcjava/mrcclasses/editcode.txt which includes IBM and mrc pre-defined codes. The mrc pre-defined codes are called user defined code, so you can either change or define your new edit code within this section.

Summary of IBM Edit Codes

Edit Code
Name

Commas

Decimal
Point

Sign for
Negative

Decimal
or Blank

Positive
Example

Negative
Example

None

No

No

No Sign

 

1234567

1234567

1

Yes

Yes

No Sign

.00 or 0

12,345.67

12,345.67

2

Yes

Yes

No Sign

Blanks

12,345.67

12,345.67

3

No

Yes

No Sign

.00 or 0

12345.67

12345.67

4

No

Yes

No Sign

Blanks

12345.67

12345.67

A

Yes

Yes

CR

.00 or 0

12,345.67

12345.67CR

B

Yes

Yes

CR

Blanks

12,345.67

12345.67CR

C

No

Yes

CR

.00 or 0

12345.67

12345.67CR

D

No

Yes

CR

Blanks

12345.67

12345.67CR

J

Yes

Yes

– (minus)

.00 or 0

12,345.67

12,345.67-

K

Yes

Yes

– (minus)

Blanks

12,345.67

12,345.67-

L

No

Yes

– (minus)

.00 or 0

12345.67

12345.67-

M

No

Yes

– (minus)

Blanks

12345.67

12345.67-

Y

No

No

No Sign

 

1234567

1234567

Z

No

No

No Sign

 

1234567

1234567

N

Yes

Yes

– (floating)

.00 or 0

12,345.67

-12,34567

O

Yes

Yes

– (floating)

Blanks

12,345.67

-12,34567

P

No

Yes

– (floating)

.00 or 0

12345.67

-12345.67

Q

No

Yes

– (floating)

Blanks

12345.67

-12345.67

Note: All IBM edit codes displayed above suppress the printing of leading zeros.

Specifying Your own Edit Word

The following is a brief explanation of the rules for defining an edit word.

— Any character other than a space, ampersand (&), zero, asterisk (*), decimal point (.), comma (,), minus sign (-), or CR will be treated as a literal and will be printed wherever it occurs.

— No literal will be printed which occurs to the left of the first significant digit in a number.

— A blank in the edit word will be replaced with the digit from the corresponding position of the data field.

— An ampersand will be replaced by a space.

— To stop suppression of leading zeros, place a zero or an asterisk in the farthest right position where zero suppress is to stop. A zero will cause leading zeros to be replaced with spaces. An asterisk will cause leading zeros to be replaced with asterisks.

— Either a minus sign or CR may be used to indicate a negative number. Whichever one is used, it must appear to the right of the last digit in the number. If a number is positive, the minus sign or CR will be replaced by spaces.

— Commas or decimal points which occur to the left of the first significant digit of a number will not be printed.

As an example of how these rules are applied, the following is the edit word customer account number where the first six digits are the base customer number and the last three digits are a location code:

0____-___ where the underscores indicate spaces.

The zero indicates that leading zero suppression stops in the first digit of the customer number. The minus sign is treated as a literal since it is not to the right of the last digit in the number. If a customer's account number was 000234001, this edit word would cause the number to be displayed as 00234-001.

Note: You will notice that when you enter the edit word m-Power right justifies the edit word. This is intentional and required for your edit code to function properly.

Created: February 29, 2008 | Modified: October 25, 2013

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Database mrc-Productivity Series RPG Video Freemarker Application Properties Prompt Screens Maintainers Compiling SQL Dropdowns Bootstrap Templates Record Selections m-Painter Data Dictionary Graphs Summaries Tomcat External Objects Excel Java Getting Started Popular Retrieval Reports Build Process Calculations Dates Email Admin Form Validation DB2 Graph Properties Graphing Security Bar Graphs Advanced Report Parameters Production Administration Retrievals App Properties Maintainer Performance

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.