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: [mg32714] Re: file.txt and/or file.xls to take file in Mathematica
  • From: Albert Retey <albert.retey at visualanalysis.com>
  • Date: Thu, 7 Feb 2002 05:09:53 -0500 (EST)
  • Organization: Visual Analysis AG
  • References: <a3qri9$2aa$1@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

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
>       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

Look for ReadList in the Documentation or HelpBrowser?

Albert


  • Prev by Date: Re: Import variable and data
  • Next by Date: Re: The prime factors of n.
  • Previous by thread: file.txt and/or file.xls to take file in Mathematica
  • Next by thread: Re: file.txt and/or file.xls to take file in Mathematica