some csv feedback

[ipwizard at users.sourceforge.net]

On Tuesday 10 July 2007 00:53, Derek Atkins wrote:
> Christian Stimming <stimming at tuhh.de> writes:
> > Then, I have a conceptual addition with dates. Do you already have plans
> > for different date separators? In the struct date_format_internal there
> > is only '/'.  Eventually, the code needs to take several different date
> > separators into account. I know of 2007/06/05 and 2007-06-05 and
> > 05.06.2007, i.e. the separator is one of [/-.], but there might be
> > others. Maybe
> > http://en.wikipedia.org/wiki/Date_and_time_notation_by_country tells of
> > some, but maybe that page is just a prime example of the wiki principle
> > failing gloriously. Heh :-)
>
> The QIF code has a decent date parser, although it's in scheme
> right now.  The regex looks like:
>
>   "^ *([0-9]+) *[-/.'] *([0-9]+) *[-/.'] *([0-9]+).*$|^
> *([0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]).*$"
>
> In other words the seperators are a dash (-), slash (/), period (.),
> and single quote (').  Also note that there's no requirement that you
> use the same separator both times.  E.g. you could use 7/1'07 and this
> is a perfectly valid date.

That's true, but 7/1'07 has a different meaning than 7/1/07 esp. if bot 
versions are used in the same file. This is important if you try to import 
ancient data from the last century. Also, there is no consitant usage of the 
apostrophe version among the various products even if they come from the same 
manufacturer (Quicken in this case).

-- 

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
Windows are like... windows. Shiny, fragile, expensive.
-------------------------------------------------------------


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: signature
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20070710/965d485f/attachment.bin