DFSORT OUTREC Editing numeric fields

DFSORT OUTREC: Data Conversion DFSORT OUTREC: arithmetic with numeric/constants

Advertisements


OUTREC used to edit the numeric fields to display in the proper understandable format.

PD values are stored asintegers in a compressed internal format which is actually unreadable while printing ordisplaying the values.

OUTREC edit feature can use the edit features toinsert signs, commas, decimal points and hyphens, as appropriate, to make the PDvalues easy to interpret.

OUTREC edit feature can be used on mostly PD values.

OUTREC edits the numeric fields using the patterns.

The below are the list of patterns used in numeric fields.

  • I indicate a leading insignificant digit to be displayed as 1-9, or as blank for a leading 0.
  • T indicates a significant digit to be displayed as 0-9.
  • S before the digits indicates a leading sign. S after the digits indicates a trailing sign.
  • Any other character is justdisplayed as same.

Format Format displayValue passed Displaying Value
M0IIIIIIIIIIIIIIIIIIIIIIIIIIIIIITS+01234
-00001
1234
1-
M1TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTS-00123
+00123
00123-
00123
M2II,III,III,III,III,III,III,III,III,IIT.TTS +123450
-000020
1,234.50
0.20-
M3II,III,III,III,III,III,III,III,III,IIT.TTCR001234
12.34CR
+123456
1,234.56
M4SII,III,III,III,III,III,III,III,III,IIT.TT +0123456
+1,234.56
1234567
-12,345.67
M5SII,III,III,III,III,III,III,III,III,IIT.TTS-001234
(12.34)
+123450
1,234.50
M6III-TTT-TTTT 00123456
012-3456
12345678
1-234-56788
M7TTT-TT-TTTT 00123456
000-12-3456
12345678
012-34-5678
M8IT:TT:TT030553
3:05:53
121736
12:17:36
M9IT/TT/TT 123004
12/30/04
083104
8/31/04
M10IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIT01234
1234
00000
0
M11TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT00010
00010
01234
01234
M12SI,III,III,III,III,III,III,III,III,III,IIT +1234567
1,234,567
-0012345
-12,345
M13SI.III.III.III.III.III.III.III.III.III.IIT +1234567
1.234.567
-0012345
-12.345
M14SI III IIIIIIIIIIIIIIIIIIIIIIII IITS +1234567
1 234 567
-0012345
(12 345)
M15I III IIIIIIIIIIIIIIIIIIIIIIII IITS +1234567
1 234 567
-0012345
12 345-
M16SI III IIIIIIIIIIIIIIIIIIIIIIII IIT+1234567
1 234 567
-0012345
-12 345
M17SI'III'III'III'III'III'III'III'III'III'IIT+1234567
1'234'567
-0012345
-12'345
M18SII,III,III,III,III,III,III,III,III,IIT.TT+0123456
1,234.56
-1234567
-12,345.67
M19SII.III.III.III.III.III.III.III.III.IIT,TT+0123456
1.234,56
-1234567
-12.345,67
M20SI III IIIIIIIIIIIIIIIIIIIII IIT,TTS +0123456
1 234,56
-1234567
(12 345,67)
M21II III IIIIIIIIIIIIIIIIIIIII IIT,TTS +0123456
1 234,567
-1234567
12 345,67-
M22SI III IIIIIIIII IIII III IIIIII IIT,TT +0123456
1 234,56
-1234567
-12 345,67
M23SII'III'III'III'III'III'III'III'III'IIT.TT +0123456
1'234.56
-1234567
-12'345.67
M24SII'III'III'III'III'III'III'III'III'IIT,TT+0123456
1'234,56
-1234567
-12'345,67
M25SIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIT +01234
1234
-00001
-1
M26STTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT 1234
+01234
-1
-00001

Example: - Will update soon


DFSORT OUTREC: Data Conversion DFSORT OUTREC: arithmetic with numeric/constants

Advertisements