Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2002
*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 2002

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

Search the Archive

file.txt and/or file.xls to take file in Mathematica

  • To: mathgroup at smc.vnet.net
  • Subject: [mg32685] file.txt and/or file.xls to take file in Mathematica
  • From: Milo <milo at dmo.fee.unicamp.br>
  • Date: Wed, 6 Feb 2002 03:41:42 -0500 (EST)
  • Sender: owner-wri-mathgroup at wolfram.com

        Hi, everybody.

        Anybody could help me, please?

        I have one file in file.txt and/or file.xls,

      900              0         -0,007      0,006041       2900000
      901              0            0           0,006041       2900000
      902              0          -0,01      0,006041       2900000
      903              0         -0,016     0,006041       2900000
      904              0          0,015      0,006041       2900000
      905              0         -0,011      0,006041       2900000
      906              0          0,004      0,006041       2900000
      907              0          0,01        0,006041       2900000
      908              0          0,014      0,006041       2900000
      909              0         -0,003      0,006041       2900000
      910              0          0,008      0,006041       2900000
      911              0            0           0,006041       2900000
      912              0         -0,015      0,006041       2900000
      913              0         -0,004      0,006041       2900000
      914              0         -0,005      0,006041       2900000
      915              0          0,019      0,006041       2900000
      916              0         -0,007      0,006041       2900000
      917              0         -0,008      0,006041       2900000
      918              0          0,022      0,006041       2900000
      919              0          0,021      0,006041       2900000
      920              0          0,012      0,006041       2900000

and I need to take this form,

file={{900, 0,  -0.007, 0.00604,    2900000},
       {901,  0,    0,        0.006041,  2900000 }
       {902 , 0,  -0.01,    0.006041,  2900000}
       {903 , 0,  -0.016, 0.006041,  2900000}
       {904 , 0,   0.015 , 0.006041,  2900000}}

        How can I do?
        Thanks in advanced.
        Milo



  • Prev by Date: Add a line to the top of a comma delimited file?
  • Next by Date: Re: Add a line to the top of a comma delimited file?
  • Previous by thread: Re: Add a line to the top of a comma delimited file?
  • Next by thread: Re: file.txt and/or file.xls to take file in Mathematica