gcsummary

The function combines a number of text files generated with LabSolutions into a single Excel file

GCSUMMARY creates a summary of text files from a Shimadzu a chromatograph
The function reads the txt file automatically generated by LabSolutions software (Shimadzu GC, HPLC).

Example:
gcsummary 'folderName' 'timeStampBeginning' 'timeStampEnd'
folderName - name of the filder with the text files
timeStampBeginning - symbol that starts the timestamp (see details below). Example is '='
timeStampEnd - symbol that ends the timestamp. Example '_'

The resulting Excel file (Excel must be installed!) contains two tabs with the overall summary for all the files: the peak area and concentration (determined by the method).

The file also contains the original filename, time chromatogram taken, the timestamp from the filename (below) as well as area/concentrations of all the compounds.

The file names may contain codified time at the end as a sequence of files obtained over time.
For example, for the file with the nameFilename=1h03m30s_01.txt, the timestamp returned is 63.5 min

The TXT files generated must satisfy the following:
1. One chromatogram per TXT file. That is, there are must be many TXT
files in the folder
2. The TXT files must contain a section with Compound Results. It is
a list of all compounds defined in the LabSolutions method file
3. The method file must be the same for all the TXT files in the folder.
If the folder contains TXT files generated by various methods, they
will contain various compound names and the current script will
return an error.
4. The compound names must contain no spaces – use underscore instead.