Write to Spreadsheet adding extra rows in csv file

[crossrulz]

---

@James.M wrote:

A good rule of thumb when working with VISA or other instruments that are communicating with strings is to add an indicator in there that shows you the output and configure the indicator to be "\" display (right-click menu option). This will show you all of the whitespace characters in "\" format. Line feeds are "\n", return key is "\r", space is "\s". Those whitespace characters have caused me a lot of grief in the past.

---

Don't forget "\t" for tab.

I also find the Hex view for the string indicator very useful as well.

[James.M]

Ah yes, tab.

The only time I use Hex view is when my instrument uses hex commands, which usually isn't the case. Hex is such a pain to read.

[billko]

---

@_natalie_ wrote:

The reason I am saving each time is because I want the data to save if I have to click stop.

---

The solution to this is to create a state machine where the clicking the stop button sends you to a state where the file is colsed and the VI exits.  You can expand on the concept by going to this same state state if you encounter an error.