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