C Wright
December 11th, 1999, 01:52 PM
I am trying to convert an "old app" [cobol?] database.
The text data in the DAT file I can import with no problems except there is one numeric field that I can't seem to figure out.
If,using the old app, the one field contains
"00.00001" then in the DAT with a hex viewer I see it stored as "AC C5 27 37"
I could probably figure out just how to convert the numbers if I could make sense of the format but it gets strange quickly.
00.00001 = AC C5 27 37
00.00002 = AC C5 A7 37
00.00003 = 82 A8 FB 37
00.00004 = AC C5 27 38
00.00005 = 17 B7 51 38
..
12.34567 = DD 87 45 41
12.34568 = E8 87 45 41
..
88.88888 = 1B C7 B1 42
99.99999 = FF FF C7 42 (this is the maximum number I can save inside the app).
Someone told me that they thought this was a Cobol program and needed it's numeric data converted to IEEE standard. That's great but how?
c.w.
The text data in the DAT file I can import with no problems except there is one numeric field that I can't seem to figure out.
If,using the old app, the one field contains
"00.00001" then in the DAT with a hex viewer I see it stored as "AC C5 27 37"
I could probably figure out just how to convert the numbers if I could make sense of the format but it gets strange quickly.
00.00001 = AC C5 27 37
00.00002 = AC C5 A7 37
00.00003 = 82 A8 FB 37
00.00004 = AC C5 27 38
00.00005 = 17 B7 51 38
..
12.34567 = DD 87 45 41
12.34568 = E8 87 45 41
..
88.88888 = 1B C7 B1 42
99.99999 = FF FF C7 42 (this is the maximum number I can save inside the app).
Someone told me that they thought this was a Cobol program and needed it's numeric data converted to IEEE standard. That's great but how?
c.w.