Services & ResourcesWolfram ForumsMathGroup Archive

[Date Index] [Thread Index] [Author Index]

Re: Bug in Import?

• To: mathgroup at smc.vnet.net
• Subject: [mg54939] Re: Bug in Import?
• From: Peter Pein <petsie at arcor.de>
• Date: Mon, 7 Mar 2005 02:10:23 -0500 (EST)
• References: <cvum3g$bmp$1@smc.vnet.net> <200503030329.WAA21146@smc.vnet.net> <d09c8k$cvk$1@smc.vnet.net> <d0e6pa$osa$1@smc.vnet.net>
• Sender: owner-wri-mathgroup at wolfram.com

Hans Michel wrote:

> In[1]:= Export["test.tsv", {{"2005-01-24", "2005-02-14"}, {"2005-01-24", \
>  "2005-02-14"}}]
> 
> Out[1]= test.tsv
> 
> In[2]:= Import["test.tsv", ConversionOptions -> {"Numeric" -> False, 
> "DateStyle" \
> -> "American", "DateSeparator" -> "-"}]
> 
> Out[2]= {{2005-01-24, 2005-02-14}, {2005-01-24, 2005-02-14}}
> 
> In[3]:= Import["test.tsv"]
> 
> Out[3]= {{2005-01-24, 2005-02-14}, {2005, -1, -24, 2005, -2, -14}}
> 
> In[4]:= Import["test.tsv", ConversionOptions -> {"NumberSigns" -> {"^", 
> "*"}}]
> 
> Out[4]= {{2005-01-24, 2005-02-14}, {2005-01-24, 2005-02-14}}
> 
> In[5]:= $Version
> 
> Out[5]= 5.1 for Microsoft Windows (October 25, 2004)
> 
> Window XP Profesional
> 
> The format for Import is
> 
> Import["test.tsv", "TSV", Encoding -> None, ConversionOptions -> {...}]
> 
> That is hard to find in the Help files.
> 
> Still does not explain why the second line gets messed up. Is it the record 
> separator,  is it the number sign
> 
> Hans
> 
> No problems in Version 5.0
> In[1]:=
> Export["test.tsv", {{"2005-01-24", "2005-02-14"}, {"2005-01-24", \
> "2005-02-14"}}]
> Out[1]=
> test.tsv
> In[2]:=
> Import["test.tsv", ConversionOptions -> {"Numeric" -> False, "DateStyle"
> -> "American", "DateSeparator" -> "-"}]
> Out[2]=
> {{2005-01-24, 2005-02-14}, {2005-01-24, 2005-02-14}}
> In[3]:=
> Import["test.tsv"]
> Out[3]=
> {{2005-01-24, 2005-02-14}, {2005-01-24, 2005-02-14}}
> In[4]:=
> $Version
> Out[4]=
> 5.0 for Microsoft Windows (June 10, 2003)
> 
> 
> "DrBob" <drbob at bigfoot.com> wrote in message 
> news:d09c8k$cvk$1 at smc.vnet.net...
> 
>>Not well indexed? That's putting it mildly.
>>
>>Here's an example of use (MUCH needed in Help):
>>
>>Export["test.tsv",
>>  {{"2005-01-24", "2005-02-14"},
>>    {"2005-01-24", "2005-02-14"}}]
>>Import["test.tsv",
>>    ConversionOptions -> {"Numeric" ->
>>      False, "DateStyle" -> "American", "DateSeparator" -> "-"}]
>>
>>No matter what options are used, however...
>>
>>Why is the second record converted differently than the first?
>>
>>Bobby
>>
[...]
>>-- 
>>DrBob at bigfoot.com
>>www.eclecticdreams.net
>>
> 
> 
I think, Bobby wanted to say: "If there's a bug, why only in the second
line?"
It seems a "buggy bug" to me too.

-- 
Peter Pein
Berlin

• Follow-Ups:
  • Re: Re: Bug in Import?
    • From: Chris Chiasson <chris.chiasson@gmail.com>

• References:
  • Re: Bug in Import?
    • From: "Hans Michel" <hmichel@sdc.cox.net>