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: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] 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 <alanpbourke@fastmail.fm> wrote:

> From: Alan Bourke <alanpbourke@fastmail.fm>

> Subject: Re: Weird format

> To: profox@leafe.com

> 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: ProFox@leafe.com

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.