On 14/06/2013 09:54, email@example.com wrote: > I have a series of files of this form: > > June 7, 2013 > Tc+Naphthalene vs Temperature (oC) > > Run 1 > Tc_Naph_84_2C 3.740 ns > Tc_Naph_87_1C 3.731 ns > Tc_Naph_89_9C 3.720 ns > Tc_Naph_92_9C 3.704 ns > Tc_Naph_94_7C 3.687 ns > Tc_Naph_97_6C 3.694 ns > > > Run 2 > Tc_Naph_83_2C 3.758 ns > Tc_Naph_83_4C 3.750 ns > Tc_Naph_86_4C 3.728 ns > Tc_Naph_88_1C 3.725 ns > Tc_Naph_90_2C 3.716 ns > Tc_Naph_93_1C 3.704 ns > Tc_Naph_94_7C 3.673 ns > Tc_Naph_97_7C 3.684 ns > Tc_Naph_97_9C 3.665 ns > > > > > I used an Import command to read in the file, but now I am just sitting and= > staring, without a clue how to get the 84_2 converted to the number 84.2,e= > tc. and ending up with two lists: Run 1 and Run 2, consisting of pairs of t= > emperature and time. The temperature will eventually be converted to 1/abs= > olute temperature. > > I've read lots and lots of help, thumbed through dozens of pages of a Mathe= > matica 5 manual, and don't know where to start. I'm trying to help a 90-ye= > ar-old chemistry professor, who is currently using a calculator, but there= > will be dozens of runs of this experiment. > Import is designed to read text or binary data formatted in a standard form - e.g. CSV. Clearly your files have an ad-hoc format, so you can't expect Mathematica (or anything else) to read them without some effort!
The job is complicated by the fact that you (or the prof) used "_" rather than a decimal point, and that the number is joined on to other textual data. I am going to assume that the units (C and ns) are the same throughout, and can be discarded, and that all the temperatures have a decimal part, even if it is 0.