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>