I am trying to export data generated from several runs from chemstation to excel. From the research I have done this seems to be a pretty common problem.
I realize I could use Chemstation's Batch function , however, all my samples are unknowns so the report is useless. Realizing Chemstation can run Macros I cam across a couple of macros but they are outdated and do not work (below is a sample of the macro). When I use the macro below the output results in one column and about 10,000 rows of sequential gibberish
I called Agilent and they were no help. The tech I talked to said he would look into it but told me not to hold my breath.
If anyone has any other suggestions please let me know. I think the only way to get around it is to create a custom macro
I am using a Agilent HPLC-ELSD 1200series
chemstation (Rev: B.04.02)
--------------------------------------------------------------
Name csvfile
Local cols,runtime,signal,i,j
for j=1 to RegSize(Chromreg)
cols=DataCols (Chromreg[j])
Open "C:\temp\Signal"+Val$(j)+".csv" For Output as #5
Print "Saving C:\temp\Signal"+Val$(j)+".csv"
For i=1 To cols
runtime=Data (Chromreg[j],0,i)
signal=Data (Chromreg[j],1,i)
print#5,runtime,",",signal
Next i
Close#5
next j
Print "Finished"
endmacro
-----------------------------------------------------------------------
the .d files are just directories. If you have multiple files in a single directory you can bring them all in and export them together.
Open a dos box and navigate to the directory where all the .d directories are located. Make a directory there with a .d extension such as aiaexp.d and then run the following commands.
mkdir aiaexp.d
for /D %I in (*.d) do (copy %I\FID1A.ch aiaexp.d\%I)
ren aiaexp.d\d*.d *.cf
now you can open aiaexp.d in one go, and export it all at once. The files exported will be named signal1.cdf,signal2.cdf,etc.
There is a commercial product you can investigate.
http://www.chem2xl.com/
You can contact the specialist on this;
Mohd Touseef
Snehal Raja
00966547652090
the .d files are just directories. If you have multiple files in a single directory you can bring them all in and export them together.
Open a dos box and navigate to the directory where all the .d directories are located. Make a directory there with a .d extension such as aiaexp.d and then run the following commands.
mkdir aiaexp.d
for /D %I in (*.d) do (copy %I\FID1A.ch aiaexp.d\%I)
ren aiaexp.d\d*.d *.cf
now you can open aiaexp.d in one go, and export it all at once. The files exported will be named signal1.cdf,signal2.cdf,etc.
I agreed with Michael Michalski answer.
https://www.researchgate.net/publication/268389305_NISHAN-E-ZAFAR
I've used the macro given in the original question to write a macro suited for exporting data ready to process with MATLab (R2016b). The generated CSV file can also be used with Excel. The macro should be placed in the chemstation "CORE" folder.
My solution (as in attachment):
Name csvfile
Local cols,runtime,signal,i,chroms,path$,Button,filename$,SeqLine,vial
cols = DataCols(Chromreg)
chroms = RegSize(Chromreg)
filename$ = "test"
Button = Input("Enter the filename",filename$)
path$ = "C:\"+filename$+".csv"
Open path$ For Output as #5
print#5,"time",",","signal",",","number",",","SeqLine",",","vial"
For j=1 To chroms
print,"working on chromatogram ",j
For i=1 To cols
runtime = Data(Chromreg[j],0,i)
signal = Data(Chromreg[j],1,i)
SeqLine = ObjHdrVal(ChromReg[j],"SeqLine")
Vial = ObjHdrVal(ChromReg[j],"Vial")
print#5,runtime,",",signal,",",j,",",SeqLine,",",vial
Next i
print#5,"_"
Next j
Close#5
endmacro
Tryout other parameters to write with the macro using the following lines:
name = ObjHdrName(ChromReg[1],)
print ObjHdrVal(ChromReg[1],name)
This macro writes runtime, signal, sequence line, and vial number to a comma separated file (CSV) from chromatograms that are in ChromReg. Chromatograms are placed in ChromReg when loaded in data analysis (blue highlighted).
The first line of the CSV file contains the headers of all columns. This is not repeated for every chromatogram.
When multiple signals belong to a loaded chromatogram these are all written to the CSV file, except when not loaded.
In this macro the _ is used as end of chromatogram identifier. In the code I wrote for MATLab the _ is used to separate chromatograms.
In the attachment also the MATLab function is included.
I'm not quite experienced with programming, all feedback is welcome.
How can I get the data from openlab chemstation after running samples from Agilent LC-UV?
I know that this question could be a little bit strange but is it possible to do the contrary task? A mean, to import a csv or excel file (time vs intensity) to Chemstation software?
Thanks.
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Computer Software