How do I delete the array reference when I save to a file?

[trosier]

And the learning continues... I have a VI that saves collected data to a file. I am saving my data using an array and shift registers in a while loop. All is fine until I save my data to a file. I have four columns of data to save. My problem is that in the first column I get the array reference saved as well, ie, [0,0,0], [1,0,0], [2,0,0]. I tried using the delete from array and it does what it says it should do, it deletes the first column which is my data and the reference remains. Any ideas on how I could get rid of this? Thanks for the help in advance.

[Chaos]

I suppose you could do this in a loop with registers, but quick question...
Is there any reason why you avoided the "Write To Spreadsheet File.vi"? You can wire a 2D array into this VI and it will handle all the details for you.

[trosier]

The data that I am writing is a string format which this VI only accepts numeric.

[Dennis_Knutson]

Open Write to Spreadsheet File and look on the diagram. There are simple instructions on how to change it to accept string arrays. Don't forget to save it with a new name and to a new location

[trosier]

I just tried this and it did not work. I did not get any data in my saved file that I wanted. All I got was a 1/2 for the entire file.

[altenbach]

Are you absolutely sure you have a 2D array and not a 3D array?? 😮

What you are describing, only happens when you try to write a 3D array.
Check the help for "Array To Spreadsheet String" for details.

[trosier]

I found another way to fix my problem. Instead of taking the text right out of the array and writing it to a file I am taking the write to file data from the input to the table of the front panel which is the index array output on the block diagram. It now works fine. Thanks for all the help.