DSP Robotics Support

Is there a quick way to strip multiple lines via ruby from excel copypaste content?

The problem is with empty cells on the beginning and end of the line. Cells are tab separated.

Depends on what you want to do with the data. Should it stay text, including tabs? Or should it be a string array, where a tab without data before results in an empty string entry, like this:
tab5tabtab5return = ["", "5", "", 5]

Can be both, tab version goes for output.

Hope this helps?

I'm not exactly sure how to send to output(s) selected input lines?
(I think I messed a bit the question too).

What I'm trying to get is something like on structure in schematic.

Theme 1: cleaning excel copy/paste content from unused lines ( = selecting desired lines), but keeping formatting (tabs),

Theme 2: from that output - selecting some individual lines as arrays (which will contain empty/nil lines, sometimes on the beginning or end).

Basically I'm trying design a sort of statistical calculation sheet for measuremental data.

Like this?

Appearently there is some problem within it, because it works with simple matrix and produces an error with larger one. But I found a workaround, and it works.

For conversion between tabs and some reference mark I use something like this:



and then this little fellow works fine with indexes: