LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

3d array to spreadsheet string

Solved!
Go to solution

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

0 Kudos
Message 1 of 11
(1,648 Views)

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.

0 Kudos
Message 2 of 11
(1,589 Views)

Try changing it into a 2D array instead.


GCentral
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,571 Views)

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

0 Kudos
Message 4 of 11
(1,550 Views)

Any solution?

 

thanks

0 Kudos
Message 5 of 11
(1,515 Views)

Convert the numbers to strings inside of the loop.

 

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

0 Kudos
Message 6 of 11
(1,506 Views)

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

can you help me?

 

thanks

0 Kudos
Message 7 of 11
(1,480 Views)

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

CLAD
Passionate for LabVIEW
0 Kudos
Message 8 of 11
(1,474 Views)

as you can see in test3.vi Block Diagram:

 

Input is a 3D array,

output is a speadsheet string

 

 

0 Kudos
Message 9 of 11
(1,465 Views)
Solution
Accepted by topic author Lesterino

@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,

Message 10 of 11
(1,455 Views)