Page 1 of 1

Exporting data in Chemstation after every run

Posted: Sun Nov 18, 2012 10:01 pm
by UTimcraig
Hello, thanks to everyone on this forum, I feel like I've already learned a lot here. I have a question though. I currently have an agilent 1100 series HPLC (liquid chromatography) with a fluorescence detector and a vial autosampler. I typically am running 96 samples at a time, and the samples are named 01, 02 02, etc. Currently I have to open each result in the offline mode and export the signal from the FLD to a .CSV file for further analysis.

As you can imagine, this is very tedious. I was wondering if there is an easy way to do this with a macro of some kind? I don't really know much about writing macros and the chemstation documentation isn't really very helpful. I also am using the latest version of chemstation if that is important.
Thanks for any advice you can give me. :?:

Re: Exporting data in Chemstation after every run

Posted: Wed Nov 21, 2012 1:41 pm
by GasMan
Try this posting.

viewtopic.php?f=2&t=12183&p=60793#p60793

It is written for the GC ChemStation, not sure if it will run in the LC ChemStation.

Gasman

Re: Exporting data in Chemstation after every run

Posted: Wed Nov 21, 2012 2:07 pm
by lmh
... before exporting as a csv, what data-handling are you doing on each file? Are you sure it's not something that Chemstation could already do? If you're just integrating peaks and performing calibration you could do that in Chemstation which, if you use batch review, will then export the results for your entire 96 samples as an Excel spreadsheet or csv, whichever you prefer.