Page 1 of 1

Agilent OpenLab CSV export

Posted: Fri Jun 25, 2021 9:35 pm
by laytox
Has anyone had issues with raw data (x,y) exports from Agilent's OpenLab software in to CSV format? I cannot read any of these CSV files in to R, I have to copy and paste each one in to a txt first and read them in to R from there, which is insanely time consuming considering we're talking about hundreds of data files. When they're read in to R using read.csv they show up as a 1-column dataframe with a nonsense character in the first entry and nothing else shows up. Thanks!

Re: Agilent OpenLab CSV export

Posted: Mon Jun 28, 2021 6:13 am
by antonk
Probably you have to configure R-import to ignore BOM (Unicode marker) at beginning of file

Update:
2021-06-29 we have updated our UniChrom, so now Agilent OpenLab file format (*.dx) is supported https://www.unichrom.com/chrom/uc-ffe.shtml

Now getting CSV from .dx may look like
./ucc FileName.dx Output.csv --text.lay_mode=all