Text string to 2d array

[Joven]

May i know how can i convert the data string into array?

I need to convert the string data to array.

For example, for the data shown:

I want to remove the first 2 headers:

Then only kept the only the 4th,5th and 6th columns of each row.

 #123 remove

#324 remove

1 2 3 4 5 6

1 2 3 7 8 9

1 2 3 4 5 6

3 2 1 6 4 2

...

To become:

 4 5 6
 7 8 9
 4 5 6
 6 4 2

and saved them into 2d array of 4x3

[Joven]

Dear all,

Can it still run fast if it has around 15 k rows of data to sort and change to array?

Thank you!

[crossrulz · Accepted solution]

Open the file, read the first 2 lines using the Read From Text File (right-click on it to enable reading lines and set the count to 2), then read the rest of the file, use Spreadsheet String To Array to convert to a 2D array, and finally use Array Subset or Delete From Array to reduce to just the columns you want.