MathGroup Archive 2004

[Date Index] [Thread Index] [Author Index]

Search the Archive

Sorting text-file data into list lists

  • To: mathgroup at
  • Subject: [mg46234] Sorting text-file data into list lists
  • From: "Curt Fischer" <crf3 at>
  • Date: Thu, 12 Feb 2004 07:15:59 -0500 (EST)
  • Sender: owner-wri-mathgroup at

Dear Group:

I have a large file with lots of numeric data, in matrix form.  The rows and
the columns both have non-numeric text headers.  The comma is the delimiter.
The character at the end of lines shows up as a "paragraph" mark in MS Word;
I'm assuming it's a carriage return.

I want to import the data into a nested list, like a matrix is usually
represented in Mathematica.  But my attempts using ReadList[] have so far


                  col1 ,         col2,
row1  ,      1.00  ,,        2.00,
row2   ,      3.00   ,       -4.00

prac=ReadList["practice.txt", Record,

{{                  col1 },{         col2},{row1  },{
       1.00  },{        2.00},{row2   },{      3.00   },{       -4.00}}



What I'd like is something like {{col1, col2},{row1, 1., 2.},{row2, 3., 4.}}

What am I doing wrong?  Thanks for any insights.

Curt Fischer

  • Prev by Date: Re: queation exporting quaternions from mathematica 5
  • Next by Date: Re: extracting a list to a list, help please
  • Previous by thread: Re: NMinimize/FindMinimum and function involving NDSolve
  • Next by thread: Re: Sorting text-file data into list lists