Agilent Community
Agilent Community
  • User
  • Site
  • Search the Community
  • User
Chromatography Software
  • Technical Areas
Chromatography Software
Wiki Chemstation .CSV generation Decimal Places
  • Announcements
  • Forum
  • Files
  • Videos
  • Wiki
  • More
  • Cancel
  • +Software Collection of Resources
  • 7694B Headspace Sampler Software Support
  • Another calibration report for OpenLAB CDS ChemStation
  • Another calibration report for OpenLAB CDS EZChrom
  • Autostart macro failed error 999 in OpenLAB CDS ChemStation
  • Belarc Advisor for PC Profiling
  • Calculate date and time differences - Save date and time in IR
  • Calibration History Report (OpenLAB CDS)
  • Chemstation .CSV generation Decimal Places
  • Chemstation Chemmain Error During Startup
  • ChemStation Scheduler Commands
  • OpenLab CDS and Windows 7 Podcast
  • Computer Maintenance
  • Configuring OpenLAB CDS Chemstation for a 6890 with 3rd party detector
  • Connection to selected server failed Error 1068 - dependency service failed
  • DAMethod Register Export
  • Error Message "No Signals Available" appears when loading data
  • Error Message: Vial Range -1 to -1 - OpenLAB CDS Chemstation
  • Error: No Export File Selections Made Yet - OpenLAB CDS Chemstation
  • How to .. hide a table row based on a calculated value (OpenLAB CDS Intelligent Reporting)
  • How to ... add a percent sign to a PRSD number.
  • How to ... add LC diagnostic data to Intelligent Reports (OpenLAB CDS Intelligent Reporting)
  • How to ... add several comments to your report template without generating extra space on the report (OpenLAB CDS Intelligent Reporting)
  • How to ... align text boxes to the editor's grid (OpenLAB CDS Intelligent Reporting)
  • How to ... align uncalibrated peaks in 2 or more signals
  • How to ... auto-extract signals from a UV iso-absorbance plot
  • How to ... calculate summary statistics on computed numbers
  • How to ... calculate with a specific mutiplier or dilution factor generated by OpenLAB CDS EZChrom
  • How to ... filter for EZChrom run types QC Standard  (OpenLAB CDS Intelligent Reporting)
  • How to ... populate the template editor with your data
  • How to ... print ChemStation's live system values (OpenLAB CDS Intelligent Reporting)
  • How to ... report the number of repeated injections with OpenLAB CDS EZChrom
  • How to ... report the output of a category aggregator  (OpenLAB CDS Intelligent Reporting)
  • How to ... store a date stamp as a variable? (OpenLAB CDS Intelligent Reporting)
  • How to ... use external report parameters (OpenLAB CDS Intelligent Reporting)
  • How to ...  setup an array of compound specific parameters
  • How to configure Agilent GC headspace system within Waters Empower and ICF
  • How To Overlay Chromatograms in OpenLab ChemStation
  • How to... report sequence related customized parameters (OpenLab ChemStation Intelligent Reporting)
  • HowTo : Report the n Biggest Peaks of a sample analysis (OpenLab CDS Custom Calculator)
  • KB: Useful Free Third-Party Software Tools
  • Little script to print Text and Numbers as Results ( e.g. below detection limits ) (OpenLAB CDS Intelligent Reporting)
  • LookInMyPC - PC Profiling and Diagnostics
  • Make your own custom way of displaying the Date and Time in your reports
  • Migrating from OpenLAB CDS EZChrom Edition to OpenLab CDS Version 2.3 – Workstation to Workstation
  • MSD Error: HPMSAXQ0.DLL failed upon launching Openlab - OpenLAB CDS Chemstation
  • Notepad++
  • Openlab CDS C.01.07 and 6890 classic driver
  • Reprocessing data using a new calibration table
  • Sequence Aborted Due to File Access Error - OpenLAB CDS Chemstation
  • Sequence container/result set data will not load in navigation panel - OpenLAB CDS Chemstation
  • Video Series: OpenLab CDS for ChemStation Users
  • When trying to run a sequence, user gets error "macro has no name"

You are currently reviewing an older revision of this page.

  • History View current version

Chemstation .CSV generation Decimal Places

Sometimes one may wish Chemstation to employ more decimal places in the CSV file it generates. In this example, we discuss how to change it from two to three decimal places.

 

First:

  1. Alter epa.mac so the quant report displayed the proper number of digits.See KDB 35518.
  2. Locate the file csv.mac under the C:\msdchem\msmacros folder. Make sure you use THIS csv.mac file because there is a different file name csv.mac in the gcmacros folder, too.
  3. Make a safe copy of the correct csv.mac file. (Perhaps copy it to csv_backup.mac).
  4. Edit the correct csv.mac file:
    1. Find this line:
      format$=”””%”,#”+csvrtdigits$+”,#.##/”
    2. Change it to:
      format$=”””%”,#”+csvrtdigits$+”,#.###/”

 

This will add the third decimal place in the csv file.

 

 

41686

Privacy Statement
Terms of Use
Contact Us
Site Help