I ran across this is download files from a few securities firms.
{ABCDEFGHI represent positive 0 through 9
}JKLMNOPQR represent negative 0 through 9
256K converts to -2562
256B converts to 2562
the last field gives the last digit and the sign of the number
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of Michael Madigan
Sent: Wednesday, March 02, 2011 4:52 AM
To: ProFox Email List
Subject: Re: Weird format
here's an example
DATASET NAME: DLSMODLL.D2200.COBLIB(FMCTR001)
TIME 13:57:42
0 SEQ LVL FIELD NAME FORMAT START
LENGTH
291 05 WX-BAL-ACCT-BAL ZS 7 2 810
9
292 05 WX-BAL-PT-BAL ZS 7 2 819
9
293 05 WX-BAL-TOT-INS-BAL ZS 7 2 828
9
294 05 WX-BAL-TOT-PT-PAY-AMT ZS 7 2 837
9
295 05 WX-BAL-TOT-PT-ADJ-AMT ZS 7 2 846
9
296 05 WX-BAL-TOT-ROOM-CHG-AMT ZS 7 2 855
9
297 05 WX-BAL-POSTED-SINCE-XFR-BD ZS 7 2 864
9
298 05 WX-BAL-FINAL-BL-BAL ZS 7 2 873
9
299 05 FILLER C 3 882
3
300 05 WX-BAL-INS-GRP(1) G 885
32
--- On Wed, 3/2/11, Alan Bourke <[email protected]> wrote:
> From: Alan Bourke <[email protected]>
> Subject: Re: Weird format
> To: [email protected]
> Date: Wednesday, March 2, 2011, 4:06 AM
> Could they be xBase-style picture
> codes as opposed to a data type? Z
> being 'blank if zero' .
>
> --
> Alan Bourke
> alanpbourke (at) fastmail (dot) fm
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/00ff01cbd8e1$9da8aeb0$d8fa0c10$@com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
