LabVIEW

cancel
Showing results for
Did you mean:

Solved!
Go to solution

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

Message 1 of 11
(1,634 Views)

Rif.: 3d array to spreadsheet string

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.

Message 2 of 11
(1,575 Views)

Re: 3d array to spreadsheet string

Try changing it into a 2D array instead.

There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
Message 3 of 11
(1,557 Views)

Re: 3d array to spreadsheet string

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

Message 4 of 11
(1,536 Views)

Any solution?

thanks

Message 5 of 11
(1,501 Views)

Re: 3d array to spreadsheet string

Convert the numbers to strings inside of the loop.

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

Message 6 of 11
(1,492 Views)

Re: 3d array to spreadsheet string

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

can you help me?

thanks

Message 7 of 11
(1,466 Views)

Re: 3d array to spreadsheet string

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

Passionate for LabVIEW
Message 8 of 11
(1,460 Views)

Re: 3d array to spreadsheet string

as you can see in test3.vi Block Diagram:

Input is a 3D array,

Message 9 of 11
(1,451 Views)
Solution
Accepted by Lesterino

Re: 3d array to spreadsheet string

@Lesterino wrote:

as you can see in test3.vi Block Diagram:

Input is a 3D array,

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,

Message 10 of 11
(1,441 Views)