exported data format

[Vtem]

Hello,

I'm trying to export an 2D array with a specified number of rows, and 4 columns from Labview to an excel file. The problem I'm having is that the indicated array format does not export properly to excel. What should be the fourth column of each row ends up below that row's second column. Basically I have this: 

Transient 1       Max Value       Min Value    

                       Pass/fail

Transient 2       etc....

And I want this:

Transient 1       Max Value       Min Value       Pass/Fail

Transient 2       etc.

I had this problem before getting the min value in the correct spot but the fix I used for that doesn't work for this because it must go through the within range node. I've tried delimiters and many other things but can't seem to crack it.

Specifically my program is taking readings from a scope (a max and min value) a certain number of times as specified by the user. Each reading is checked to make sure it is within a certain min and max value and declares pass or fail. When I look at the array indicator on the front panel it is displayed the way I want but when it exports it acts as indicated above. I'm using Tektronix scopes and Labview 2012.

Thank you for your help.

[littlesphaeroid]

I'm not seeing this problem in your code. I simplified the diagram a bit. Could it be that you need to prvide a header for the fourth column? I went ahead and did this, but the result int eh excel file is the same for me.

[crossrulz · Accepted solution]

The Textronix scopes use an End Of Line at a termination character.  So the data in the VISA Read has an EOL at the end.  Use a Trim Whitespace to remove these right after the VISA Read.

[littlesphaeroid]

Good point. You can view these invisible characters by right clicking on a string indicator or contant and selecting "'\' Codes Display".

[Vtem]

this fixed it perfectly thanks guys.