Working with CSV files

Recorded data from the Enforcer can be exported in CSV files for further processing in Excel, Matlab or other data processing programs. Although the CSV format is simple, there are a few pitfalls that can be easily avoided with right steps.

CSV (Comma Separated Values) is a plain text based file format for storing tabular data. It is a fairly loose standard and thus different applications tend to handle CSV differently. There are two main formats used:

    • The International Format is used in English speaking countries and Asia. It uses a comma (,) as field separator, and a period (.) as decimal mark in numeric data. This is the format used by the Enforcer.
    • The Continental Format is used in countries where the decimal mark is a comma (,). To avoid problems, a semicolon (;) is used to separate fields. This format is common in continental Europe and South America.Decimal marks: Full Stop "." – Blue Comma "," – Green Eastern Arabic numerals – Red Data unavailable – Grey

    This means that the process is somewhat different depending on the regional settings of your computer. Matlab, for instance, will always work with the international format but Excel uses the format specified by the regional settings.

    Below are detailed instructions on how to work with the Enforcer CSV files in different regions and with different programs.