Subject: | |
From: | |
Reply To: | |
Date: | Tue, 7 Oct 2008 14:41:59 +0100 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Some more data extraction fun!
The dictionary has the troublesome fields defined as CHAR(12) so I guess whatever is in them is encoded somehow within the no-longer-supported application. I am no longer convinced this is packed decimals problem.
Anyone who can suggest how 52 characters ( remembering the leading 0x0a ) are seen in miniterm from a 12 character field.
" L¸qMMMM"
and
"ñXÁ8MMMM"
are both meant to be 12 'character' fields.
Is there some way to see a hex dump of these files so I can see the real data?
I suspect the 52 character field has tab characters encoded, for example.
On the original extract both the above fields include 0x0a, I think, causing the wordwraps which prompted my original extract confusion.
Dictionary extract:
DIMENSIONS CHAR X(12)
.LENGTH NUM 4 0 4 ^^^^^^.^^^^
.WIDTH NUM 4 0 4 ^^^^^^.^^^^
.LENGTH-UOM CHAR X(2)
.WIDTH-UOM CHAR X(2)
.MACHINE-TYPE CHAR X(12)
.TOOL-TYPE CHAR X(12)
FROM quiz > prompt
set report limit 200
access BOM-STRUCTURE
define dl char*1="~"
report summary &
COMPANY dl &
PRODUCT dl &
PRODUCT-1 dl &
DEFAULT-QTY dl &
LENGTH dl &
LENGTH-UOM dl &
WIDTH dl &
WIDTH-UOM dl &
ITEM-NO dl &
OFF-DATE dl &
ON-DATE dl &
OPTION-FLAG dl &
PRINT-FLAG dl &
QTY-PER-ASSEMBLY dl &
MACHINE-TYPE dl & <<<< These are the ones which throw wierd data
TOOL-TYPE <<<< These are the ones which throw wierd data
set subfile name BOM706 portable
go
SS~ST~ST~00019 ~FF66 ~+0000000000~+1213158432~+0538976288~ ~ ~ ~+0000000000~+0019911115~TL~ ~+0000000000HOT HOT
SS~ST~ST~00019 ~P01701 ~+0000000000~+0000455000~+0000115000~MM~MM~ ~+0000000000~+0019950118~RM~ ~+0000001000
ñXÁ8MMMM
ñXÁ8MMMM
SS~ST~ST~00020 ~P00308 ~+0000000000~+0000925000~+0000047000~MM~MM~ ~+0000000000~+0019911115~TP~ ~+0000001000
SS~00020 ~24 ~+0000000000~+1347568979~ ~+1414088517~ ~ ~+0000000000~+0019911115~MC~ ~+0000000000~PRESTIGE ~PRESTIGE
SS~00021 ~P00308 ~+0000000000~+0000675000~MM~+0000160000~MM~ ~+0000000000~+0019911115~TP~ ~+0000001000~
L¸qMMMM~
L¸qMMMM
SS~00021 ~P01701 ~+0000000000~+0000675000~MM~+0000160000~MM~ ~+0000000000~+0019950118~RM~ ~+0000001000~ L¸qMMMM~
L¸qMMMM
SS~00021 ~111F ~+0000000000~+1213158432~ ~+0538976288~ ~ ~+0000000000~+0019911115~TL~ ~+0000000000~HOT ~HOT
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|