Professional Detailing1 min read

Coating Data Imports: Check Decimal Separators Before Calculating

A comma or full stop can represent a decimal separator differently across data sources. Validate imported numeric fields before using coating measurements or quantities in calculations.

Updated · NANOLAB Knowledge

The key distinction

An import may turn a value into text, split it into columns or interpret it as a different number. Keep the original file and document the source convention so corrections remain traceable.

Practical checks

  1. Identify the source's decimal and field separators.
  2. Check representative small and large values after import.
  3. Reconcile totals or known reference values before analysis.

Example

Illustrative example: a source value of 1,25 is intended as one and a quarter, but an import treats the comma as a separator. The resulting table no longer contains the intended measurement.

Scope and limits

Do not infer the correct value from the expected product result. Verify the source format and preserve the original data before correcting the imported analysis file.

Related guidance

Ask NANOLAB about the exact product and intended use. Use the current product documentation for formulation-specific instructions.