some csv feedback

[Derek Atkins]

Thomas,

ipwizard at users.sourceforge.net 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

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