Convert 1D array to 2D when have space between cells

[leandrofeder]

Hello guys,

I am receiving the data like that

I'm getting the data this way, and I need each empty cell to be added to the next row of the array

As in the image below, as it is now and as it should be

I ask for your help, because I am not able to accomplish this

[Andrey_Dmitriev · Accepted solution]

---

@leandrofeder wrote:

... I need each empty cell to be added to the next row of the array

As in the image below, as it is now and as it should be

I ask for your help, because I am not able to accomplish this

---

There are many ways how to do this, for example

[Andrey_Dmitriev · Accepted solution]

Or if you prefer to have  cycles, then two more variants:

I'm not sure, may be here kind of "Rube Goldberg Code" or not, but don't see any other ways for further simplification.

[altenbach · Accepted solution]

---

@leandrofeder wrote:

I'm getting the data this way, and I need each empty cell to be added to the next row of the array

---

It semes you are not adding any empty cells to the next row. You are discarding empty cells and taking them as signal to start a new row.

Something is seems wrong with your element 56 in the input array. Would that need special handling?

If we can assume that the first element is not an empty string, here's a simple explicit solution. (If the first or last element can be an empty string, small tweaks are needed, but that should get you started.)

[altenbach]

---

@Andrey_Dmitriev wrote:

There are many ways how to do this, for example

---

Element at index 56 seems to contain some binary data, so there is a nonzero chance that a random \t  or even double-linefeed could occur, breaking everything downstream.

---

@Andrey_Dmitriev wrote:

Or if you prefer to have  cycles, then two more variants:

...

I'm not sure, may be here kind of "Rube Goldberg Code" or not, but don't see any other ways for further simplification.

---

I agree that there can still be significant simplification, e.g. no blue data at all! (see my similar code above). I also think that the constant array splitting might be hard on the memory manager, depending how smart the compiler can simplify it or not.

More efficient solution can be made, for example if we know the maximum row length beforehand.