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