Numeric fields are stored in the database without any formatting whatsoever. Apply format (sometimes called edit codes as well) codes to numeric fields allows you to add formatting to make your numerical values more readable for your end-user. For instance instead of showing your user a value of 9876532, a format code would allow you to instead show the value as $9,876,532. The value, of course is the same but the additional formatting makes it much easier to quickly read and better understand the value.<\/p>\n\n\n\n
m-Power ships with many format codes by default (see table below), but you can also create your own custom format codes as well.<\/p>\n\n\n\n
Defined edit codes are stored in a text file \/mrcjava\/mrcclasses\/editcode.txt which includes default 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.<\/p>\n\n\n\n
Summary of Default Edit Codes<\/em><\/strong><\/p>\n\n\n\n The following is a brief explanation of the rules for defining an edit word.<\/p>\n\n\n\n — 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.<\/p>\n — No literal will be printed which occurs to the left of the first significant digit in a number.<\/p>\n — A blank in the edit word will be replaced with the digit from the corresponding position of the data field.<\/p>\n — An ampersand will be replaced by a space.<\/p>\n — 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.<\/p>\n — 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.<\/p>\n — Commas or decimal points which occur to the left of the first significant digit of a number will not be printed.<\/p>\n<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n 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:<\/p>\n\n\n\n 0____-___ where the underscores indicate spaces.<\/p>\n\n\n\n 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.<\/p>\n\n\n\n Introduction Numeric fields are stored in the database without any formatting whatsoever. Apply format (sometimes called edit codes as well) codes to numeric fields allows you to add formatting to make your numerical values more readable for your end-user. For instance instead of showing your user a value of 9876532,…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[266],"ht-kb-tag":[],"class_list":["post-1165","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-general"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=1165"}],"version-history":[{"count":16,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1165\/revisions"}],"predecessor-version":[{"id":14023,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1165\/revisions\/14023"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=1165"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=1165"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=1165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Edit Code Name<\/td> Commas<\/td> Decimal point<\/td> Sign for Negative<\/td> Decimal or Blank<\/td> Positive Example<\/td> Negative Example<\/td><\/tr> None<\/td> No<\/td> No <\/td> No Sign<\/td> <\/td> 1234567<\/td> 1234567<\/td><\/tr> 1<\/td> Yes<\/td> Yes <\/td> No Sign<\/td> .00 or 0<\/td> 12,345.67<\/td> 12,345.67<\/td><\/tr> 2<\/td> Yes <\/td> Yes <\/td> No Sign<\/td> Blanks<\/td> 12,345.67 <\/td> 12,345.67 <\/td><\/tr> 3<\/td> No <\/td> Yes <\/td> No Sign<\/td> .00 or 0 <\/td> 12345.67<\/td> 12345.67<\/td><\/tr> 4<\/td> No <\/td> Yes <\/td> No Sign <\/td> Blanks<\/td> 12345.67<\/td> 12345.67<\/td><\/tr> A<\/td> Yes <\/td> Yes <\/td> CR <\/td> .00 or 0 <\/td> 12,345.67<\/td> 12,345.67CR<\/td><\/tr> B<\/td> Yes <\/td> Yes <\/td> CR <\/td> Blanks<\/td> 12,345.67 <\/td> 12,345.67 <\/td><\/tr> C<\/td> No <\/td> Yes <\/td> CR <\/td> .00 or 0 <\/td> 12345.67<\/td> 12345.67CR<\/td><\/tr> D<\/td> No <\/td> Yes <\/td> CR <\/td> Blanks<\/td> 12345.67<\/td> 12345.67CR<\/td><\/tr> J<\/td> Yes <\/td> Yes <\/td> – (minus)<\/td> .00 or 0 <\/td> 12,345.67<\/td> 12,345.67-<\/td><\/tr> K<\/td> Yes <\/td> Yes <\/td> – (minus)<\/td> Blanks<\/td> 12,345.67<\/td> 12,345.67-<\/td><\/tr> L<\/td> No <\/td> Yes <\/td> – (minus)<\/td> .00 or 0 <\/td> 12345.67<\/td> 12345.67-<\/td><\/tr> M<\/td> No <\/td> Yes <\/td> – (minus) <\/td> Blanks<\/td> 12345.67<\/td> 12345.67-<\/td><\/tr> Y<\/td> No <\/td> No <\/td> No Sign <\/td> <\/td> 1234567<\/td> 1234567<\/td><\/tr> Z<\/td> No <\/td> No <\/td> No Sign <\/td> <\/td> 1234567<\/td> 1234567<\/td><\/tr> N<\/td> Yes <\/td> Yes <\/td> – (floating) <\/td> .00 or 0<\/td> 12,345.67<\/td> -12,34567<\/td><\/tr> O<\/td> Yes <\/td> Yes <\/td> – (floating) <\/td> Blanks<\/td> 12,345.67<\/td> -12,34567<\/td><\/tr> P<\/td> No <\/td> Yes <\/td> – (floating) <\/td> .00 or 0 <\/td> 12345.67<\/td> -12345.67<\/td><\/tr> Q<\/td> No<\/td> Yes <\/td> – (floating) <\/td> Blanks<\/td> 12345.67<\/td> -12345.67<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Specifying Your own Edit Word<\/em><\/strong><\/h3>\n\n\n\n
\n