Services & ResourcesWolfram ForumsMathGroup Archive

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

Re: Re: Bug in Import?

• To: mathgroup at smc.vnet.net
• Subject: [mg54914] Re: Re: Bug in Import?
• From: "Hans Michel" <hmichel at sdc.cox.net>
• Date: Sun, 6 Mar 2005 00:56:03 -0500 (EST)
• References: <cvum3g$bmp$1@smc.vnet.net> <200503030329.WAA21146@smc.vnet.net> <d09c8k$cvk$1@smc.vnet.net>
• Reply-to: "Hans Michel" <hmichel at sdc.cox.net>
• Sender: owner-wri-mathgroup at wolfram.com

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
>
> On Wed, 2 Mar 2005 22:29:21 -0500 (EST), Hans Michel <hmichel at sdc.cox.net> 
> wrote:
>
>> Mark:
>>
>> Late 2 cents:
>>
>> As in the Help File Under Import
>> The default ConversionOptions -> {"DateStyle", "DateSeparator",
>> "NumberSigns", "Numeric"}
>> for TVS and Table formats will impact the conversion of your data file.
>>
>> Not well indexed not even an example of use.
>>
>> Hans
>>
>> "Mark Fisher" <mark at markfisher.net> wrote in message
>> news:cvum3g$bmp$1 at smc.vnet.net...
>>> (1) I export a data set that has two identitcal rows.
>>> (2) I use "!!" to display the stored file, showing that it contains two
>>> identical rows.
>>> (3) I import the file, the result of which does *not* have two identical
>>> rows: The first row is different from the second row.
>>>
>>> Export["test.tsv",
>>>     {{"2005-01-24", "2005-02-14"},
>>>     { "2005-01-24", "2005-02-14"}}]
>>>
>>> !!test.tsv -->
>>>
>>> 2005-01-24    2005-02-14
>>> 2005-01-24    2005-02-14
>>>
>>> Import["test.tsv"] -->
>>>
>>> {{2005-01-24, 2005-02-14},
>>> {2005, -1, -24, 2005, -2, -14}}
>>>
>>> Surely this is a bug.
>>>
>>> (I sent this example to support at wolfram.com three weeks ago, but the
>>> only response I've received is that it's not a bug. Frankly, I don't
>>> think the tech person who responded understood the example.)
>>>
>>> I  am using version 5.1 for Windows.
>>>
>>> --Mark.
>>>
>>
>>
>>
>>
>
>
>
> -- 
> DrBob at bigfoot.com
> www.eclecticdreams.net
> 

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