Append report text adds

[gbails]

My data is being saved with a block at the end of the data. It appears to becoming in with a star due to using Array to Spreadsheet String VI. Not sure what to do to get rid of the block. The complete VI that is giving me trouble is attached.

[ShotSimon]

Hi gbails,

Do you have a sample set of data that shows the behavior that you are seeing with the Array to Spreadsheet String VI?

Thanks,

-SS

[MoReese]

It may be a control character.  Try reading the "block" into a string indicator with Codes Display enabled.  It may be a null character (0x00).

[MoReese]

Also, I forgot to mention you can use Hex Display to show the actual hex code as well.

[gbails]

When I use indicators the data is shown with a * at the end after the array to spreadsheet string sub vi. I am assuming that is what is causing the error. I tried to attach a spreadsheet with some sample data, E has the data that was entered by this VI. The end of the data has the block that I am seeking to prevent from being written.  

Thanks

[MoReese]

I copied this to a string control and it clearly shows two CR.  One within quotes and one after.  It's the one after that is giving you the block.  Check your VI, Write to spreadsheet string.  There is an extra CR coming from somewhere.

[gbails]

What does CR stand for? 

Thanks

[MoReese]

Carriage Return (Enter key without the line feed).  Are you appending this to your data anywhere?  It could also be included with any text data you are entering.

[gbails]

Not sure how but appears it must be caused by the Append labview report VI. I have attached a more simplfied vi. With notes maybe this can show you more about my problem.

Thanks