[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
>
Prev by Date:
**Re: Re: Goto Line ?**
Next by Date:
**Re: Front End Programming question**
Previous by thread:
**Re: Re: Bug in Import?**
Next by thread:
**Re: Bug in Import?**
| |