Agilent OpenLab CSV export

Discussions about chromatography data systems, LIMS, controllers, computer issues and related topics.

2 posts Page 1 of 1
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!
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
2 posts Page 1 of 1

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 1117 on Mon Jan 31, 2022 2:50 pm

Users browsing this forum: No registered users and 1 guest

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry