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

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

  • To: mathgroup at smc.vnet.net
  • Subject: [mg32756] Re: [mg32685] file.txt and/or file.xls to take file in Mathematica
  • From: Dale Horton <daleh at wolfram.com>
  • Date: Fri, 8 Feb 2002 03:49:31 -0500 (EST)
  • Sender: owner-wri-mathgroup at wolfram.com

At 02:41 AM 2/6/2002, Milo wrote:

>         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

(snip)

>       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

Import["file.txt", "Table", ConversionOptions->{"NumberPoint"->","}]

-Dale



  • Prev by Date: Re: The prime factors of n.
  • Next by Date: Re: NDSolve with side conditions:
  • Previous by thread: Re: file.txt and/or file.xls to take file in Mathematica
  • Next by thread: Comment's Style