some csv feedback

Derek Atkins warlord at MIT.EDU
Tue Jul 10 18:48:15 EDT 2007


ipwizard at writes:

>> 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).

Oh?  This is news to me.  What's the difference in meaning?


       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL:    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available

More information about the gnucash-devel mailing list