3d array to spreadsheet string

[Lesterino]

I need a spreadsheet string eliminating all rows [x, 0, 0].

[FatBoyMonchi]

Hi lesterino,

you can use the vi called Match Pattern to search the pattern you want to eliminate from the string and then use the concatenate string to concatenate the output of the match pattern before string and after string.

Hope to have understood what was your problem, but don't hesitate to contact me if you need any further help.

Bye.

[crossrulz]

Try changing it into a 2D array instead.

[Lesterino]

Very interesting, simple, Thanks!

I ask you another question, how can I put a null row between each loops? The goal is to obtain a carriage return between the spreadsheet string loop values:

29.171098,-7.003361,0.000000
29.630650,-4.693034,0.000000
29.907520,-2.353773,0.000000
30.000000,-0.000000,0.000000

78.296261,0.000000,72.011625
78.054900,3.321259,72.011625
77.332304,6.622042,72.011625
76.132929,9.881998,72.011625

[Lesterino]

Any solution?

thanks

[RavensFan]

Convert the numbers to strings inside of the loop.

After each 2-D array, concatenate another linefeed to the string.

[Lesterino]

I tried to do this, but it does not work.

can you help me?

thanks

[jatinpatel1489@gmail.com]

Well, you have mentioned your output but what exactly is your input?

[Lesterino]

as you can see in test3.vi Block Diagram:

Input is a 3D array,

output is a speadsheet string

[ghighuphu · Accepted solution]

---

@Lesterino wrote:

as you can see in test3.vi Block Diagram:

Input is a 3D array,

output is a speadsheet string

---

Dear Lesterino,

you have three inputs on your "Concatenate Strings" between the shift registers. Change their order: the first input for the second input. Then the new data are pasted at the end of the data coming from the shift register. If you need a reverese order of the string (as it is now), you have to reorder the inputs on your "Concatenate Strings": 1. the line-feed 2. the new data string 3. the data from the shift register.

Cheers,