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

Version 1

    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)