How to ... export sequence results to comma separated txt files (OpenLAB CDS Intelligent Reporting)

Document created by agilent Employee on Mar 28, 2016
Version 1Show Document
  • View in full screen mode

Here’s an example template for ChemStation C.01.03. It generates a comma separated result test file, when saving the sequence summary report as .txt.

It will work with all higher versions and very likely with EZCHrom, too. It consists of 4 single fields and a 1 column table with the following definitions:

 

Single fields:

="Sequence:"+"," +Sequence_Name

="Sequence acquired:"+"," +(Sequence_AcquiredDate)

="Sequence acquired by:"+","+Sequence_AcquiredBy

="Instrument:"+","+Instrument_Name

 

1 column table header:

Sample,sample type,Injection time,Compound,Retention time,Area,Amount,Concentration

 

1 column table content:

=Sample_Name+","+cstr(Sample_Type)+","+(Injection_AcquiredDate)+","+Compound_Name+","+cstr(Peak_RetentionTime)+","+cstr(Peak_Area)+","+cstr(Compound_Amount)+","+cstr(Compound_Concentration)

 

 

(originally posted in OpenLAB Forum: https://zohodiscussions.com/openlabcdsforum#Topic/68030000000182003

2015 May 5 by Bernhard Etrich)

Outcomes