string to 2d array

[minazza]

Hi all,

I have the attached string sent via TCP server and received from my client, I want it to be formatted in a 2 row n columns (n is the number of channel). I've attached the input string and the result I want. Any help?

Thank you

[wiebe@CARYA · Accepted solution]

I'd go for this:

So first replace all ';' with '\n' so Spreadsheet String To Array will work nicely. The rows\columns will be transposed. The Transpose 2D Array will fix that.

I doubt there will be a more efficient way both performance-wise, as in programming effort. All three functions are very fast (when used this way).

[minazza]

Thank you!