Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
1996
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 1996

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

Search the Archive

Re: help! to input data...

  • To: mathgroup at smc.vnet.net
  • Subject: [mg4228] Re: help! to input data...
  • From: welter at .ti.com (Jason Welter)
  • Date: Tue, 18 Jun 1996 03:28:06 -0400
  • Organization: Texas Instruments
  • Sender: owner-wri-mathgroup at wolfram.com

In article <4pit53$jk5 at dragonfly.wolfram.com>, tcdoe+ at pitt.edu says...
>
>well, silly me.
>I thought i was pretty good at the basics of mathematica, but today i 
>tried to input some numerical data that was comma delimited. i.e.
>
>456,-45,21,0,5
>43,25,3,66,65
>...
>...
>...
>
>it is a large data file (10Mb+) with 5 numbers per line. i can't
>convert the commas to tabs easily.

You don't need to convert the commas to tabs.

Solution #1: Open the file and put a "{" before the first number
and a "}" after the last.  This creats one big list and can be
read in using something like data = <<"C:\\temp\\data.txt";

Solution #2: Load the file into MS Word and insert "{{" before the
first number and add a "}}" after the last.  Do a global search
and replace of the paragraph character with "},^P{" where ^P is
the paragraph character.  This creats an array  and can be
read in using something like data = <<"C:\\temp\\data.txt";
This preserves the structure of the data file, the first line of
data becomes record #1 data[[1]], the second number of the fifth
record is data[[5,2]].  You may need to clean up the end of the
file with your work processor.

I know there are ways to read almost anything in using ReadList
but quickly editing my data files with Excel and Work is a very
fast and easy to remember way to fix data access in Mathematica.


==== [MESSAGE SEPARATOR] ====


  • Prev by Date: Re: How to read *.bmp *.wav files?
  • Next by Date: Re: Binary files under MS Windows
  • Previous by thread: help! to input data...
  • Next by thread: Re: help! to input data...