The LOINC Mapping Validator
- The input file must be in CSV format using comma as the column separator.
- The first row must be the header (column names) row and column names must be unqiue.
- There must be a column for the LOINC number and a column for the unit.
- If the value in the cell contains commas, double quotes or newlines characters, you will need to enclose the value in double quotes and where you want to use double quotes, repeat them twice.
(Example: A cell value of Say "Hi" would become "Say ""Hi""".)
Batch Validation of LOINC Mappings in CSV Files
Please select the file to validate, fill out the LOINC number column name and the unit column name fields below, and then click the "Validate" button to process the file. For requirements on the input file format, please expand the introductory descriptions in the section above using the "Show more..." link there.
|CSV File to Validate:|
|What is the column name for the LOINC number?|
|What is the column name for the UCUM unit?|
It may take a while. When it finishes, depending on your browser's configuration, it will either ask you to specify where to save the results file, or directly save to your browser's pre-configured save location. For details on the result file format, please see output file format.