Re: Export table problem
- To: mathgroup at smc.vnet.net
- Subject: [mg30931] Re: [mg30891] Export table problem
- From: Tomas Garza <tgarza01 at prodigy.net.mx>
- Date: Thu, 27 Sep 2001 02:16:48 -0400 (EDT)
- References: <200109230616.CAA22636@smc.vnet.net>
- Sender: owner-wri-mathgroup at wolfram.com
I tried your problem under both Versions 4.0 and 4.1 and could not replicate
the situation you report. I used the same two lines that follow:
In[1]:=
x = Round[100*Table[{i, i/5, i/3}, {i, 1, 20}]]/100.
Out[1]=
{{1., 0.2, 0.33}, {2., 0.4, 0.67}, {3., 0.6, 1.}, {4., 0.8, 1.33}, {5., 1.,
1.67}, {6., 1.2, 2.}, {7., 1.4, 2.33}, {8., 1.6, 2.67}, {9., 1.8,
3.}, {10., 2., 3.33}, {11., 2.2, 3.67}, {12., 2.4, 4.}, {13., 2.6,
4.33}, {14., 2.8, 4.67}, {15., 3., 5.}, {16., 3.2, 5.33}, {17., 3.4,
5.67}, {18., 3.6, 6.}, {19., 3.8, 6.33}, {20., 4., 6.67}}
In[2]:=
Export["table.txt", x, "Table"]
Out[2]=
"table.txt"
Of course the results appear in the corresponding directories Math4.0 and
Math4.1, respectively. Still, opening in Excel File|Open|..... yields in
both cases the 20 x 3 table|
1 0.2 0.33
2 0.4 0.67
3 0.6 1
4 0.8 1.33
5 1 1.67
6 1.2 2
7 1.4 2.33
8 1.6 2.67
9 1.8 3
10 2 3.33
11 2.2 3.67
12 2.4 4
13 2.6 4.33
14 2.8 4.67
15 3 5
16 3.2 5.33
17 3.4 5.67
18 3.6 6
19 3.8 6.33
20 4 6.67
Tomas Garza
Mexico City
----- Original Message -----
From: <maarten.vanderburgt at icos.be>
To: mathgroup at smc.vnet.net
Subject: [mg30931] [mg30891] Export table problem
> Hallo,
>
> Below I generate a table of numbers, which I round to get numbers with 2
> decimals precision. I want to export them in a ascii file. In my output
> file I get some numbers like 1.4000000000000001 instead of simply 1.4.
> Where does this extra 0.0000000000000001 come from? Is this a bug? How
can
> I get rid of it without editing my file.?
>
> Thanks for your help
>
> Maarten van der Burgt
> Belgium
>
> Round[100*Table[{i,i/5,i/3},{i,1,20}]]/100.;
> Export["c:\\temp\\table.txt",%,"Table"]
>
> When I open table.txt I see:
> 1. 0.2 0.33
> 2. 0.4 0.67
> 3. 0.6 1.
> 4. 0.8 1.33
> 5. 1. 1.67
> 6. 1.2 2.
> 7. 1.4000000000000001 2.33
> 8. 1.6 2.67
> 9. 1.8 3.
> 10. 2. 3.33
> 11. 2.2 3.67
> 12. 2.4 4.
> 13. 2.6 4.33
> 14. 2.8000000000000003 4.67
> 15. 3. 5.
> 16. 3.2 5.33
> 17. 3.4 5.67
> 18. 3.6 6.
> 19. 3.8000000000000003 6.33
> 20. 4. 6.67
>
>
- References:
- Export table problem
- From: maarten.vanderburgt@icos.be
- Export table problem