Re: How to read a data file in text format?_from a new learner

*To*: mathgroup at smc.vnet.net*Subject*: [mg62414] Re: How to read a data file in text format?_from a new learner*From*: Bill Rowe <readnewsciv at earthlink.net>*Date*: Wed, 23 Nov 2005 01:13:19 -0500 (EST)*Sender*: owner-wri-mathgroup at wolfram.com

On 11/22/05 at 4:42 AM, readnewsciv at earthlink.net (Bill Rowe) wrote: >On 11/21/05 at 3:54 AM, yanshanguke at 163.com (deepthinker) wrote: >>I want to import a data file that produced by spectrometer into >>mathemathica and fit the data. The file is in text format >>("data.txt"). The data in the file is characters: first line:some >>descriptions. second line: 200, 45.5. third line: 201,44.3. and so >>on. If you open the file "data.txt", you will see: >>transmission ratio by UV-3150 >>200, 45.5 >>201,44.3 >>202,44.6 >>203,46.7 >>.... >>1,000,75.5 >>1,000,76.3 >>How to import these data in to mathematica 5.0 and plot the figure? >Probably the simplest way to deal with this file would be to use >Import. That is: >data=Cases[Import["data.txt", "CSV"], {_?NumberQ,_?NumberQ}]; >ListPlot[data]; >Should do what you want. In looking over my comments above, I realized I made an assumption that may not be valid. In possing the problem a comma character appears to be used in two distinct ways, as a field separator and as a separator within a number to improve readability. If the file literally has this format, there will be no simple/easy way to read the data into Mathematica or any other program for that matter. The point is if a comma is interpreted as a field separator, then the line 1,000,75.3 will be seen as three numbers 1, 0, and 75.3. But if the comma is interpreted as part of a number this line is likely to be interpreted as 100075.3, a single number. When I suggested using Import I assumed this line would actually appear in the file as 1000,75.5 That is the comma will always be a field separator which is how it would be treated by Import. -- To reply via email subtract one hundred and four

**Re: statistics questions**

**Re: Boolean Integral**

**Re: Re: Re: How to read a data file in text format?_from a new learner**

**Export[] to XLS**