Author: Grigore Dolghin
Posted: 2011-03-02 at 09:05:11
Now I dare you to do a SELECT on that data set, lol ;)
> -----Original Message-----
> From: profoxtech-bounces@leafe.com [mailto:profoxtech-
> bounces@leafe.com] On Behalf Of Carl Lindner
> Sent: Wednesday, March 02, 2011 3:56 PM
> To: profoxtech@leafe.com
> 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: 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/000001cbd8e2$d98c7320$8ca55960$@gmail.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.