How to segment a 1D array into a 2D array?

[gisti87]

Here's a real dataset in a spreadsheet file.

[Hummer1]

the data seems to be both comma seperated and space (or tab) seperated.  The data seems to be two intigers seperated by a comma and then a tab and the chance for two more intigers or two zeros.  They almost look like coordinate pairs. 

[altenbach]

No, the comma is the decimal sperator in certain countries. We just need to read the with the correct localization settings. 🙂

So:  11,825 == 11.825

[Hummer1]

Ahhhh!...forgot for a moment.

Thanks.

Well, then, I am confused...

Is the rule

read data, if zero skip...if nonzero add to array row until next zero is encountered?

Hummer1

"When flying, a number accurately presenting the average granite content of a cloud is of little use."

[gisti87]

"Is the rule

read data, if zero skip...if nonzero add to array row until next zero is encountered?"

Yes. 🙂

[Alain_S]

---

altenbach wrote:

We just need to read the with the correct localization settings. 🙂

---

Or, open the file with Word or Notepad and replace the "," by a "." 🙂

[altenbach · Accepted solution]

Try something like this (LabVIEW 8.5):

Seems to work with most typical inputs and can probably be simplified further.

(Still needs a few tweaks, e.g. if the array contains only one element and that element is zero the output is a 2D array with a zero instead of an empty array).

Message Edited by altenbach on 11-17-2009 11:52 PM

[gisti87]

That's a working solution, thank you!