ChemStation How to create a macro to Extracting Specific Absorbance Signal from 3D IsoPlot

Hi there,

You can extract a specific signal from the DAD data by using the LoadChrom command;

LoadChrom [Detector], [TimeRange], [WLRange], [RefWLRAnge], ToReg

So for example LoadChrom, 0:0, 215:225, , ChromReg would load 220 nm with a bandwidth of 10 and no reference and would add this signal to the ChromReg register.  Note that this will not actually display the signal graphically; the DrawSignals macro can be used for displaying it although it's not necessary if you just want to extract the data to a .csv file.

DrawSignals [DrawAnew], [DrawSig], [ChromNormalized], [ChromOverlaid], [ShowFileInfo], [FreezeLayout], [DrawCmd$], [ZoomSeparate]

ex.; DrawSignals 1, 3,,,,1

So you could have a macro that loads all the desired extracted signals to the ChromReg register and you can then go through the data (starting at the original RegSize + 1) by accessing that register using the signal numbers and looping through all of the data points as DataCols(ChromReg[signalIndex]) much like the example that you linked; Data(ChromReg[signalIndex], 0, a) would be the time and Data(ChromReg[signalIndex], 1, a) - you could then print that out to a text file and format it as you wish.  You could also go through the timepoints first and loop through the signals for each timepoint if you wanted an output file formatted as you had above.

If this is part of a sequence, you could also set up your macro to run on all the files in the sequence and output the data file name and data to your .csv file.  You could also do that with single files in a folder, but you might need to access that list with an external script (ChemStation can run scripts through the ExecWait/ExecNoWait commands).

Hope this helps.