Now I dare you to do a SELECT on that data set, lol ;) > -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of Carl Lindner > Sent: Wednesday, March 02, 2011 3:56 PM > To: [email protected] > Subject: RE: Weird format > > 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/[email protected] ** 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.
