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.