Hi Toni,
I think the data is being read correctly, but because of the
large values in the last couple of records, the LIST command
formats the output so you can't see the significant figures in
variables E and F. Try:
yes? list/format=(8e12.4) a,b,c,d,e,f,g,h
DATA SET: ./asciidata.dat
X: 0.5 to 54.5
Column 1: A
Column 2: B
Column 3: C
Column 4: D
Column 5: E
Column 6: F
Column 7: G
Column 8: H
0.6250E+01 0.8223E+00 0.7385E+00 0.3750E+01 0.5355E-01
0.5963E-01 0.1330E+01 0.1481E+01
0.1250E+02 0.1157E+01 0.1002E+01 0.6250E+01 0.7925E-01
0.9160E-01 0.1543E+01 0.1784E+01
0.1875E+02 0.1392E+01 0.1173E+01 0.8750E+01 0.1002E+00
0.1190E+00 0.1761E+01 0.2089E+01
0.2500E+02 0.1561E+01 0.1291E+01 0.1125E+02 0.1183E+00
0.1432E+00 0.1977E+01 0.2391E+01
0.3125E+02 0.1681E+01 0.1369E+01 0.1375E+02 0.1343E+00
0.1649E+00 0.2197E+01 0.2698E+01
0.3750E+02 0.1765E+01 0.1420E+01 0.1625E+02 0.1486E+00
0.1847E+00 0.2422E+01 0.3010E+01
0.4375E+02 0.1819E+01 0.1449E+01 0.1875E+02 0.1617E+00
0.2030E+00 0.2653E+01 0.3331E+01
0.5000E+02 0.1850E+01 0.1462E+01 0.2125E+02 0.1738E+00
0.2201E+00 0.2892E+01 0.3661E+01
...
0.3188E+03 0.6494E-02 0.4700E-02 0.1288E+03 0.8514E+00
0.1181E+01 0.2716E+03 0.3753E+03
0.3250E+03 0.5863E-04 0.4240E-04 0.1312E+03 0.2554E+01
0.3570E+01 0.9087E+05 0.1257E+06
0.3312E+03 0.8755E-41 0.6331E-41 0.1338E+03 0.9363E+07
0.7415E+07 0.9664E+30 0.1337E+31
0.3375E+03 0.0000E+00 0.0000E+00 0.1362E+03 0.1000E+08
0.1000E+08 0.1366E+31 0.1889E+31
Toni Mira wrote:
Hi Ferreters,
I am having an strange problem with a ASCII file.
It contains 8 columns, but when I run:
yes? file/form=free/skip=2/var=a,b,c,d,e,f,g,h data.dat
yes? list a,b,c,d,e,f,g,h
I get:
DATA SET: ./data.dat
X: 0.5 to 54.5
Column 1: A
Column 2: B
Column 3: C
Column 4: D
Column 5: E
Column 6: F
Column 7: G
Column 8: H
A B C D E F G
H
1 / 1: 6.2 0.822 0.738 3.8 0. 0. 1.330E+00
1.481E+00
2 / 2: 12.5 1.157 1.002 6.2 0. 0. 1.543E+00
1.784E+00
3 / 3: 18.8 1.392 1.173 8.8 0. 0. 1.761E+00
2.089E+00
4 / 4: 25.0 1.561 1.291 11.2 0. 0. 1.977E+00
2.391E+00
5 / 5: 31.2 1.681 1.369 13.8 0. 0. 2.197E+00
2.698E+00
6 / 6: 37.5 1.765 1.420 16.2 0. 0. 2.422E+00
3.010E+00
7 / 7: 43.8 1.819 1.449 18.8 0. 0. 2.653E+00
3.331E+00
8 / 8: 50.0 1.850 1.462 21.2 0. 0. 2.892E+00
3.661E+00
9 / 9: 56.2 1.863 1.461 23.8 0. 0. 3.139E+00
4.003E+00
10 / 10: 62.5 1.860 1.450 26.2 0. 0. 3.396E+00
4.358E+00
11 / 11: 68.8 1.845 1.430 28.8 0. 0. 3.663E+00
4.728E+00
12 / 12: 75.0 1.819 1.402 31.2 0. 0. 3.943E+00
5.115E+00
13 / 13: 81.2 1.784 1.369 33.8 0. 0. 4.237E+00
5.521E+00
14 / 14: 87.5 1.742 1.331 36.2 0. 0. 4.546E+00
5.948E+00
15 / 15: 93.8 1.694 1.289 38.8 0. 0. 4.872E+00
6.399E+00
16 / 16: 100.0 1.640 1.244 41.2 0. 0. 5.217E+00
6.876E+00
17 / 17: 106.2 1.582 1.197 43.8 0. 0. 5.580E+00
7.377E+00
18 / 18: 112.5 1.523 1.148 46.2 0. 0. 5.961E+00
7.905E+00
19 / 19: 118.8 1.457 1.096 48.8 0. 0. 6.380E+00
8.483E+00
20 / 20: 125.0 1.389 1.042 51.2 0. 0. 6.828E+00
9.103E+00
21 / 21: 131.2 1.320 0.988 53.8 0. 0. 7.311E+00
9.770E+00
22 / 22: 137.5 1.249 0.933 56.2 0. 0. 7.832E+00
1.049E+01
23 / 23: 143.8 1.177 0.877 58.8 0. 0. 8.396E+00
1.127E+01
24 / 24: 150.0 1.105 0.822 61.2 0. 0. 9.011E+00
1.212E+01
25 / 25: 156.2 1.033 0.767 63.8 0. 0. 9.683E+00
1.305E+01
26 / 26: 162.5 0.961 0.712 66.2 0. 0. 1.042E+01
1.407E+01
27 / 27: 168.8 0.890 0.658 68.8 0. 0. 1.123E+01
1.519E+01
28 / 28: 175.0 0.820 0.605 71.2 0. 0. 1.214E+01
1.644E+01
29 / 29: 181.2 0.751 0.554 73.8 0. 0. 1.315E+01
1.783E+01
30 / 30: 187.5 0.684 0.504 76.2 0. 1. 1.427E+01
1.938E+01
31 / 31: 193.8 0.618 0.454 78.8 0. 1. 1.557E+01
2.118E+01
32 / 32: 200.0 0.555 0.407 81.2 0. 1. 1.700E+01
2.317E+01
33 / 33: 206.2 0.494 0.362 83.8 0. 1. 1.867E+01
2.547E+01
34 / 34: 212.5 0.436 0.319 86.2 0. 1. 2.058E+01
2.812E+01
35 / 35: 218.8 0.381 0.279 88.8 0. 1. 2.281E+01
3.120E+01
36 / 36: 225.0 0.330 0.241 91.2 0. 1. 2.542E+01
3.481E+01
37 / 37: 231.2 0.282 0.206 93.8 0. 1. 2.850E+01
3.906E+01
38 / 38: 237.5 0.238 0.173 96.2 0. 1. 3.216E+01
4.412E+01
39 / 39: 243.8 0.198 0.144 98.8 1. 1. 3.653E+01
5.018E+01
40 / 40: 250.0 0.163 0.118 101.2 1. 1. 4.179E+01
5.745E+01
41 / 41: 256.2 0.131 0.096 103.8 1. 1. 4.812E+01
6.620E+01
42 / 42: 262.5 0.105 0.076 106.2 1. 1. 5.569E+01
7.667E+01
43 / 43: 268.8 0.083 0.060 108.8 1. 1. 6.465E+01
8.907E+01
44 / 44: 275.0 0.065 0.047 111.2 1. 1. 7.505E+01
1.035E+02
45 / 45: 281.2 0.051 0.037 113.8 1. 1. 8.684E+01
1.197E+02
46 / 46: 287.5 0.040 0.029 116.2 1. 1. 9.994E+01
1.379E+02
47 / 47: 293.8 0.031 0.023 118.8 1. 1. 1.147E+02
1.582E+02
48 / 48: 300.0 0.024 0.018 121.2 1. 1. 1.322E+02
1.826E+02
49 / 49: 306.2 0.018 0.013 123.8 1. 1. 1.557E+02
2.150E+02
50 / 50: 312.5 0.012 0.009 126.2 1. 1. 1.928E+02
2.663E+02
51 / 51: 318.8 0.006 0.005 128.8 1. 1. 2.716E+02
3.753E+02
52 / 52: 325.0 0.000 0.000 131.2 3. 4. 9.087E+04
1.257E+05
53 / 53: 331.2 0.000 0.000 133.8 9363014. 7415051. 9.664E+29
1.337E+30
54 / 54: 337.5 0.000 0.000 136.2 9999949. 9999949. 1.366E+30
1.889E+30
Why Ferret can not read correctly some columns?
I am attaching the data file.
Thanks in advance.
Toni
COMPANY
NAME
0.6250000E+01 0.8223196E+00 0.7384809E+00 0.3750000E+01 0.5355120E-01 0.5963226E-01 0.1329954E+01 0.1480975E+01
0.1250000E+02 0.1157465E+01 0.1001507E+01 0.6250000E+01 0.7924550E-01 0.9159790E-01 0.1543323E+01 0.1783721E+01
0.1875000E+02 0.1391786E+01 0.1173044E+01 0.8750000E+01 0.1002382E+00 0.1189551E+00 0.1760637E+01 0.2089022E+01
0.2500000E+02 0.1560950E+01 0.1290576E+01 0.1125000E+02 0.1183411E+00 0.1431756E+00 0.1977159E+01 0.2391456E+01
0.3125000E+02 0.1681243E+01 0.1369369E+01 0.1375000E+02 0.1342778E+00 0.1649224E+00 0.2197191E+01 0.2697701E+01
0.3750000E+02 0.1764514E+01 0.1419915E+01 0.1625000E+02 0.1485968E+00 0.1847450E+00 0.2422143E+01 0.3010082E+01
0.4375000E+02 0.1818907E+01 0.1449078E+01 0.1875000E+02 0.1616703E+00 0.2030417E+00 0.2653274E+01 0.3330555E+01
0.5000000E+02 0.1850279E+01 0.1461601E+01 0.2125000E+02 0.1737638E+00 0.2201094E+00 0.2891768E+01 0.3660895E+01
0.5625000E+02 0.1862991E+01 0.1460911E+01 0.2375000E+02 0.1850735E+00 0.2361765E+00 0.3138784E+01 0.4002794E+01
0.6250000E+02 0.1860385E+01 0.1449571E+01 0.2625000E+02 0.1957489E+00 0.2514218E+00 0.3395507E+01 0.4357949E+01
0.6875000E+02 0.1845080E+01 0.1429546E+01 0.2875000E+02 0.2059080E+00 0.2659899E+00 0.3663172E+01 0.4728112E+01
0.7500000E+02 0.1819179E+01 0.1402388E+01 0.3125000E+02 0.2156452E+00 0.2799990E+00 0.3943106E+01 0.5115151E+01
0.8125000E+02 0.1784390E+01 0.1369339E+01 0.3375000E+02 0.2250385E+00 0.2935482E+00 0.4236751E+01 0.5521077E+01
0.8750000E+02 0.1742132E+01 0.1331416E+01 0.3625000E+02 0.2341533E+00 0.3067224E+00 0.4545690E+01 0.5948101E+01
0.9375000E+02 0.1693588E+01 0.1289461E+01 0.3875000E+02 0.2430458E+00 0.3195950E+00 0.4871696E+01 0.6398680E+01
0.1000000E+03 0.1639775E+01 0.1244187E+01 0.4125000E+02 0.2517651E+00 0.3322315E+00 0.5216751E+01 0.6875564E+01
0.1062500E+03 0.1582500E+01 0.1196940E+01 0.4375000E+02 0.2605081E+00 0.3448820E+00 0.5579732E+01 0.7377218E+01
0.1125000E+03 0.1522732E+01 0.1148405E+01 0.4625000E+02 0.2693965E+00 0.3577141E+00 0.5961329E+01 0.7904599E+01
0.1187500E+03 0.1457196E+01 0.1095937E+01 0.4875000E+02 0.2777576E+00 0.3698694E+00 0.6379871E+01 0.8483042E+01
0.1250000E+03 0.1389396E+01 0.1042245E+01 0.5125000E+02 0.2861110E+00 0.3820106E+00 0.6828463E+01 0.9103028E+01
0.1312500E+03 0.1319858E+01 0.9876839E+00 0.5375000E+02 0.2944919E+00 0.3941864E+00 0.7310963E+01 0.9769887E+01
0.1375000E+03 0.1249055E+01 0.9325719E+00 0.5625000E+02 0.3029351E+00 0.4064451E+00 0.7831866E+01 0.1048985E+02
0.1437500E+03 0.1177420E+01 0.8772013E+00 0.5875000E+02 0.3114753E+00 0.4188361E+00 0.8396439E+01 0.1127021E+02
0.1500000E+03 0.1105356E+01 0.8218408E+00 0.6125000E+02 0.3201483E+00 0.4314076E+00 0.9010886E+01 0.1211953E+02
0.1562500E+03 0.1033236E+01 0.7667422E+00 0.6375000E+02 0.3289908E+00 0.4442126E+00 0.9682563E+01 0.1304800E+02
0.1625000E+03 0.9614153E+00 0.7121438E+00 0.6625000E+02 0.3380428E+00 0.4573056E+00 0.1042021E+02 0.1406769E+02
0.1687500E+03 0.8902324E+00 0.6582722E+00 0.6875000E+02 0.3473455E+00 0.4707454E+00 0.1123433E+02 0.1519313E+02
0.1750000E+03 0.8200131E+00 0.6053465E+00 0.7125000E+02 0.3569457E+00 0.4845962E+00 0.1213754E+02 0.1644177E+02
0.1812500E+03 0.7510735E+00 0.5535799E+00 0.7375000E+02 0.3668933E+00 0.4989281E+00 0.1314520E+02 0.1783488E+02
0.1875000E+03 0.6841902E+00 0.5035307E+00 0.7625000E+02 0.3775048E+00 0.5141682E+00 0.1426625E+02 0.1938482E+02
0.1937500E+03 0.6177454E+00 0.4539654E+00 0.7875000E+02 0.3877342E+00 0.5289173E+00 0.1556624E+02 0.2118221E+02
0.2000000E+03 0.5550160E+00 0.4073126E+00 0.8125000E+02 0.3994150E+00 0.5456370E+00 0.1700474E+02 0.2317121E+02
0.2062500E+03 0.4942542E+00 0.3622452E+00 0.8375000E+02 0.4113842E+00 0.5627709E+00 0.1866664E+02 0.2546914E+02
0.2125000E+03 0.4362799E+00 0.3193555E+00 0.8625000E+02 0.4240586E+00 0.5808829E+00 0.2058320E+02 0.2811927E+02
0.2187500E+03 0.3813834E+00 0.2788388E+00 0.8875000E+02 0.4375382E+00 0.6001103E+00 0.2281032E+02 0.3119895E+02
0.2250000E+03 0.3298492E+00 0.2408879E+00 0.9125000E+02 0.4519340E+00 0.6206071E+00 0.2541856E+02 0.3480577E+02
0.2312500E+03 0.2819519E+00 0.2056883E+00 0.9375000E+02 0.4673671E+00 0.6425388E+00 0.2849682E+02 0.3906266E+02
0.2375000E+03 0.2379504E+00 0.1734137E+00 0.9625000E+02 0.4839615E+00 0.6660763E+00 0.3215629E+02 0.4412342E+02
0.2437500E+03 0.1980795E+00 0.1442205E+00 0.9875000E+02 0.5018370E+00 0.6913828E+00 0.3653400E+02 0.5017765E+02
0.2500000E+03 0.1625365E+00 0.1182384E+00 0.1012500E+03 0.5210874E+00 0.7185850E+00 0.4179332E+02 0.5745116E+02
0.2562500E+03 0.1314621E+00 0.9555683E-01 0.1037500E+03 0.5417484E+00 0.7477276E+00 0.4811745E+02 0.6619756E+02
0.2625000E+03 0.1049135E+00 0.7620437E-01 0.1062500E+03 0.5637494E+00 0.7787061E+00 0.5568940E+02 0.7666980E+02
0.2687500E+03 0.8282709E-01 0.6012365E-01 0.1087500E+03 0.5868562E+00 0.8111894E+00 0.6465174E+02 0.8906526E+02
0.2750000E+03 0.6497481E-01 0.4713903E-01 0.1112500E+03 0.6106471E+00 0.8445882E+00 0.7505439E+02 0.1034529E+03
0.2812500E+03 0.5092422E-01 0.3692833E-01 0.1137500E+03 0.6346011E+00 0.8781772E+00 0.8683550E+02 0.1197473E+03
0.2875000E+03 0.4003026E-01 0.2901721E-01 0.1162500E+03 0.6583938E+00 0.9115121E+00 0.9993974E+02 0.1378718E+03
0.2937500E+03 0.3149210E-01 0.2282052E-01 0.1187500E+03 0.6823782E+00 0.9450963E+00 0.1146675E+03 0.1582420E+03
0.3000000E+03 0.2448202E-01 0.1773537E-01 0.1212500E+03 0.7080553E+00 0.9810326E+00 0.1322449E+03 0.1825536E+03
0.3062500E+03 0.1829080E-01 0.1324636E-01 0.1237500E+03 0.7385378E+00 0.1023661E+01 0.1557335E+03 0.2150412E+03
0.3125000E+03 0.1240703E-01 0.8982359E-02 0.1262500E+03 0.7801213E+00 0.1081749E+01 0.1928038E+03 0.2663144E+03
0.3187500E+03 0.6494300E-02 0.4699842E-02 0.1287500E+03 0.8513587E+00 0.1181128E+01 0.2716122E+03 0.3753174E+03
0.3250000E+03 0.5862745E-04 0.4239503E-04 0.1312500E+03 0.2554455E+01 0.3569998E+01 0.9087470E+05 0.1256941E+06
0.3312500E+03 0.8755313E-41 0.6331066E-41 0.1337500E+03 0.9363014E+07 0.7415051E+07 0.9664327E+30 0.1336729E+31
0.3375000E+03 0.0000000E+00 0.0000000E+00 0.1362500E+03 0.9999949E+07 0.9999949E+07 0.1365989E+31 0.1889376E+31
|