HelloI converted an 3x2 array to 2x3 array by transpose 2D array, then I used "array to spreadsheet string" vi to convert my 2x3 array to string. The string format is %f. The array consists of numbers and text like:frequency capacitance resistance100 10 100when I try to write the data on text file the number at middle becomes 0. I used probes for debugging. I found out that the problem is in output of the "array to spreadsheet string"vi. Input data ( which is a 2D array) is ok but in output (which is a string) the middle data are zero!! I can not find the reason. Thank you in advance for your help

The problem is in the magnitude of your value. Primary parameter is 14.5 p, which rounds to zero because it is rounding to 6 decimal places and pico is too small. Use %g instead of %f for your format code. I don't understand why you are building values onto the ends of empty array. A lot of that cluster and array manipulation seems unnecessary. I removed the while loop and the agilent subVI's so I could run this. But basically your code can be stripped down to this. PS: Because you attached the code, we could zoom in and see that the problem was with the magnitude of your data, which we couldn't see on the original partial screenshot of the code.

LabVIEW

array to spreadsheet string- why middle data becomes zero

Solved!

Author

Dear RavensFan

I attached the vi above

Thank you

Message 11 of 12

(876 Views)

Author

Thank you dear RavensFan

It's done:)

Since I am new in labview sometimes I use unnecessary vi's.

and about your note: yes you are right 🙂

Message 12 of 12

(869 Views)

LabVIEW

array to spreadsheet string- why middle data becomes zero

Re: array to spreadsheet string- why middle data becomes zero

Re: array to spreadsheet string- why middle data becomes zero