Importing Data as an arbitrary matrix

Question

I have a .txt file which have following form

Name1 number1 number2 number3 Name2 number4 number5 number6 Name3 number6 number8 number9

I want to import these data as following matrix

new={{number1,number2,number3,number4,number5,number6,number7,number8,number9}}

namely a 1x9 matrix. When I try this code

new = Part[Import["path\filename.txt", "Table"], Range[1, 3],2 ;; 4]

I get a 3x3 matrix as

new={{number1,number2,number3},{number4,number5,number6},{number7,number8,number9}}

due to using the Part command. How can I build a 1x9 matrix where all numbers are placed in one row by importing data from the file or convert the 3x3 matrix obtained from above code to a 1x9 matrix?

@Henrik Schumacher Thanks, but this command give me a 9x1 matrix rather than 1x9 one. Do you know a way which produces a 1x9 matrix by importing data from the file directly? — Wisdom, Apr 09 '18 at 12:53
Well, the matrix is stored as $3 \times 3$ matrix, so we have to convert it. Fasted way to obtain a $1 \times 9$ matrix might be ArrayReshape[new, {1, Times @@ Dimensions[new]}]. — Henrik Schumacher, Apr 09 '18 at 13:04
@Henrik Schumacher That's right! it works perfectly. Thanks. Can you explain about your code a bit? — Wisdom, Apr 09 '18 at 13:31
Well, have a look into the documentation of ArrayReshape. Times @@ Dimensions[new] just computes $3 \cdot 3 = 9$ in a way that also works for other matrix sized of new. — Henrik Schumacher, Apr 09 '18 at 13:33
@Henrik Schumacher Right, I applied it to my original matrix which was a 14x7 matrix. I will study the documentation. — Wisdom, Apr 09 '18 at 13:37
@Henrik Schumacher Thanks,It seems you're expert in Mathematica, Is there a way that I ask you my questions about Mathematica privatley? — Wisdom, Apr 09 '18 at 14:02
Well, if it's not too many questions, you can contact me under this email address: Uncompress["1:eJxTTMoPClZiYGAoTs4ozU1MzkgtcsjMKy7JTSzJ0CsqL8nQTQQJ5umlpAIANGgO/A=="]. (Execute the command in Mathematica.) But also this site provides much helpful info for new users. — Henrik Schumacher, Apr 09 '18 at 14:11
@HenrikSchumacher an answer should be posted so this doesn't show up as "Unanswered" — GenericAccountName, Apr 12 '18 at 17:59

Henrik Schumacher · Answer 1 · 2018-04-12T20:03:58.370

1

Just for completeness:

With[{new = Import["path\filename.txt", "Table"]},
  ArrayReshape[new, {1, Times @@ Dimensions[new]}
]

edited Apr 12 '18 at 20:03

answered Apr 12 '18 at 18:32

Henrik Schumacher

106,770
7
179
309

Importing Data as an arbitrary matrix

1 Answers1