Re: Mathematica v8: import a space-delimited table of numbers?

*To*: mathgroup at smc.vnet.net*Subject*: [mg115852] Re: Mathematica v8: import a space-delimited table of numbers?*From*: Peter Pein <petsie at dordos.net>*Date*: Sat, 22 Jan 2011 03:25:16 -0500 (EST)*References*: <ihbjoe$de1$1@smc.vnet.net>

On 21.01.2011 10:30, Gordon Robertson wrote: > I routinely use Import[] for "CSV" and "TSV" files, but now need to > import a space-delimited file in which each line has a string as the > first element, and then thousands of (space-delimited) decimal numbers. > > After looking at the help documentation, and previous posts on > MathGroup, I don't see a simple way to Import while specifying that the > separator is a space (in R's read.table, I'd use sep=" "). > > I expect that I could read in the file as a table, split lines on > spaces, then map ToExpression across the numbers in each row. Have I'd > missed something in the documentation? > > Thanks for your help. > > Gordon Hi Gordon, simpliy use an option; no need for ToExpression because Import will recognize strings and numbers: In[1]:= FullForm[read=Import[ToFileName[{$HomeDirectory,"Desktop"},"test.txt"],"Table", "Separator"->" "]] Out[1]//FullForm= List[List["first",1.2`,2.3`,3.4`,4.5`],List["second",9.8`,8.7`,7.6`,6.5`]] and separate the numeric data with data = Rest/@read or data = read[[All,2;;]] Cheers, Peter -------* copy of test.txt: *------- first 1.2 2.3 3.4 4.5 second 9.8 8.7 7.6 6.5 ------* end of copy *-------