Google Answers Logo
View Question
 
Q: Chemstaion File Format ( Answered,   1 Comment )
Question  
Subject: Chemstaion File Format
Category: Science
Asked by: chemguy-ga
List Price: $20.00
Posted: 13 Oct 2002 09:31 PDT
Expires: 12 Nov 2002 08:31 PST
Question ID: 76082
I'd like to know what the format of Agilents Chemstation is so that I
can write some VBA code to import it into excel. I am interested in
the .CH files in particular.
Answer  
Subject: Re: Chemstaion File Format
Answered By: webadept-ga on 20 Oct 2002 20:44 PDT
 
Hi, 

This guy has a perl script which will translate Agilent (HP)
ChemStation data files to simple xy data table for subsequent use in
graphing software. He is willing to send you his source code for this
if you email him.

http://bluebox.ces.uoguelph.ca/utilities.shtml

With this source code you should be able to find his functions which
deal with the file format and go from there in you VB application. The
*.ch files are raw x,y data for A/D Detector “x”, Channel “y” and
appear to be basic text.

On the Agilent website I found several utilites and one of them
exports data from Chemstation to Excel, so you may be able to simply
use the macro or incorporate it into your VB program.
http://www.chem.agilent.com/cag/servsup/usersoft/main.html


Search used 
+"chemstation" +perl +format

webadept-ga

Request for Answer Clarification by chemguy-ga on 08 Dec 2002 18:11 PST
Dear Webadept,
I contacted the link you give below and he states that his scripts
will not open the .CH files I am interested in. Would you please try
again.

Regards,

Chemguy

Clarification of Answer by webadept-ga on 08 Dec 2002 22:54 PST
Can you post on a website a link to one of these files you are
interested in so I can take a look at it?

Clarification of Answer by webadept-ga on 08 Dec 2002 22:57 PST
Just for future questions as well, normally it is better to get back
to your researcher before the question expires, but as I suggested in
my previous CR, I'm willing to help if I can. As soon as you have them
on a webserver or FTP somewhere, post your CR here and I'll take a
look at the files and see if either I can do it or if I can find a
program which does.

Thanks again, 

webadept-ga

Request for Answer Clarification by chemguy-ga on 15 Dec 2002 19:01 PST
Dear Webadept,
I appreciate the effort on your part and I appologize for my slowness
of response. I am setting up a web page so that I can get the files to
you. As soon as I do, I'll post it here (Hopefully will be tomorrow.)

Regards,
chemguy
Comments  
Subject: Re: Chemstation File Format
From: willie-ga on 13 Oct 2002 10:13 PDT
 
I've had a dig around the Agilent Chemstation tech support site, but
couldn't find what you wanted. If you want to have a look around
yourself, they are at (
http://www.chem.agilent.com/Scripts/cag_techsupport.asp )

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy