Reading Data From Agilent 34401

[cnoyes23]

I'm reading the voltage measured on an Agilent 34401 using Single Point measurment in a For Loop (so that I can graph results in real time). The only issue I'm having is that when I try to write the data to a file, it isn't written in two columns (time/loop literation and voltage) like I thought it would be. Instead, it is written as a set of information about each iteration of the loop (including date, time and a bunch of "Delta_X" values). Would anyone know how to write data to a file so that it simply displays in two column form?

Thanks.

[billko]

---

@cnoyes23 wrote:

I'm reading the voltage measured on an Agilent 34401 using Single Point measurment in a For Loop (so that I can graph results in real time). The only issue I'm having is that when I try to write the data to a file, it isn't written in two columns (time/loop literation and voltage) like I thought it would be. Instead, it is written as a set of information about each iteration of the loop (including date, time and a bunch of "Delta_X" values). Would anyone know how to write data to a file so that it simply displays in two column form?

Thanks.

---

I don't know.  Have you tried correctly parsing the results?  😉

Sorry, I couldn't resist.

[Gregory]

Please run once with an indicator of what is being written to the spreadsheet. Then right click the indicator and click "change to constant". Then upload your VI. Thanks,

Gregory

[cnoyes23]

Billko I've only recently starting doing this. Can't tell if your response was sarcastic or just something simple I've didn't know how to do. How would I parse the results?

[Gregory]

We don't know what your results are yet, but if you follow my post above we will be able to see if what data you are actually getting.

[cnoyes23]

These are the results that I'm getting (the numbers with the blurbs of text). For reference (and I'm not sure this is even possible) I attached an image of the data written from a previous file on this computer that came out in column form. I also attached an image of my VI because the computer I'm using isn't connected to the internet anymore.

[cnoyes23]

Files were too big to be sent together. Here is the data form I'm trying to get.

[cnoyes23]

And here's the picture of my VI

[Gregory]

Well it's going to be pretty hard to offer help without having the actual VI. But, if you are getting that header every time, then maybe search for the ***End of Header*** in order to find the data you are after.

[Gregory]

Some comments:

Don't Initialize and Close your instrument inside the loop, that should only be done once at the beginning and end of a program (usually).

Do continue to read and write inside the loop.

Don't use write to measurement file express VI.

Do use write to spreadsheet or the report generation toolkit.

Also, what is the data in the left column, just the loop iteration or data point number? Or is it some other variable we don't see here?