Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed2a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <python-python-list@m.gmane.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.010
X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'parsing': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'subject:number': 0.09; 'bug': 0.12; 'leakage': 0.16; 'message- id:@4ax.com': 0.16; 'negative,': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'recognised': 0.16; 'subject:CSV': 0.16; 'value"': 0.16; 'wrong).': 0.16; '(the': 0.22; 'feb': 0.22; 'appears': 0.22; 'format,': 0.24; 'url:home': 0.24; 'possibly': 0.26; 'header:X-Complaints-To:1': 0.27; 'went': 0.31; "skip:' 10": 0.31; 'decimal': 0.31; 'this.': 0.32; 'figure': 0.32; 'period': 0.33; "i'd": 0.34; 'transaction': 0.35; 'but': 0.35; 'there': 0.35; 'really': 0.36; '+0200,': 0.36; 'skip:> 10': 0.36; 'done': 0.36; 'charset:us-ascii': 0.36; 'starting': 0.37; 'to:addr:python-list': 0.38; 'does': 0.39; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'exposure': 0.60; 'signal': 0.60; 'back': 0.62; 'college': 0.70; '2015': 0.84; 'cobol': 0.84; 'generation,': 0.84; 'received:108': 0.93
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject: Re: CSV and number formats
Date: Sun, 01 Feb 2015 11:46:38 -0500
Organization: IISS Elusive Unicorn
References: <maki32$iav$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Gmane-NNTP-Posting-Host: adsl-108-73-116-218.dsl.klmzmi.sbcglobal.net
X-Newsreader: Forte Agent 6.00/32.1186
X-No-Archive: YES
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.18363.1422809201.18130.python-list@python.org>
Lines: 26
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1422809201 news.xs4all.nl 2859 [2001:888:2000:d::a6]:38175
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:85006

On Sun, 1 Feb 2015 08:45:54 +0200, "Frank Millman" <frank@chagford.com>
declaimed the following:

>If it is negative, it appears as '+00000-21.45'
>
>Predictably, decimal.Decimal does not like this.
>
>Is this a recognised format, and is there a standard way of parsing it? If 
>not, I will have to special-case it, but I would prefer to avoid that if 
>possible.
>

	If it were showing as "0000021-45" I'd think leakage from a COBOL
decimal type (the COBOL-74 on my college computer normal numeric type was
BCD, and used the decimal place to hold the sign of the value).

	Possibly a bug in data generation, or it may have been done as a signal
that this is not a transaction value... The limited exposure I have
(Quicken) is that the "starting value" for a reconciliation is carried over
from the last reconciliation and does not rely upon the starting value of
the transaction report (and any difference really means having to back up
to the prior period to figure out what went wrong).
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/