CSV is an abbreviation for Comma Separated Values and a CSV file is a file that separates the tabular data with commas. When a CSV file is opened in a CSV reader like Microsoft Excel the values are automatically shown in a table. It is among the most used formats for exchanging data.
An example of CSV:
column1,column2,column3, firstrowdata1,firstrowdata2,firstrowdata3 secondrowdata1,secondrowdata2,secondrowdata3
In this depiction, you can notice that each value is separated by a comma. The first line is always table head, it can also be called the name of a data column. Every following line/row has the real data which is also restricted by file size constraints.
CSV in MS Excel has different formats that you come across while saving your file with "Save As". Though it depends on the version of Excel you are using. Excel in MS Office 365 has 4 types of CSV formats.
CSV UTF-8 (Comma delimited)
CSV (Comma delimited)
Among these 4, CSV (Macintosh) is dedicated to Mac computers while all others are available in MS Windows. All four have distinguished kind of character coding, i,e the terminating character for a record or line used in Macintosh type is CR (Carriage Return). On the other hand, the other three utilize CR/LF (Carriage Return/Line Feed). These three formats are furtherly separated by the type of code page they use. The code page relates to the encoding of individual characters. If your data has the use of foreign characters or accented characters then Code pages difference takes place. The code pages used by each format furtherly depends on
the Excel version
language version of Excel
your regional settings configuration
Starting point of this tutorials is an embedded system that produces a trace for received can data. The trace contains 4 data columns. 2 integer values (delay in ms and no of received data) and 2 float values (internal axis data)), preceded by a timestamp in ms.
timeInMillies;delay;received;axisA;axisB 1565436982527 ;140 ;0 ;0.0 ;0.0 1565436982578 ;51 ;0 ;0.0 ;0.0 1565436982606 ;28 ;0 ;0.0 ;0.0 1565436982618 ;12 ;0 ;0.0 ;0.0 1565436982639 ;21 ;0 ;0.0 ;0.0 1565436982658 ;19 ;0 ;0.0 ;0.0 1565436982686 ;28 ;0 ;0.0 ;0.0 1565436982766 ;80 ;170314 ;2128.925 ;112.04868421052633 1565436982770 ;4 ;0 ;0.0 ;106.44625 1565436982798 ;28 ;0 ;0.0 ;101.12393750000001 1565436982810 ;12 ;0 ;0.0 ;96.06774062500001 1565436982830 ;20 ;0 ;0.0 ;91.26435359375002 1565436982851 ;21 ;0 ;0.0 ;86.70113591406252 1565436982871 ;20 ;201401 ;10070.05 ;612.3687106973067 1565436982891 ;20 ;0 ;0.0 ;581.7502751624413 1565436982911 ;20 ;0 ;0.0 ;552.6627614043193
A view combines a set of plots organized in rows. You may switch between multiple views using the the combo box in the top right corner.
You can use an unlimited number of views for a record file. The upper-right button in the toolbar is used to switch between multiple views.
The signal area is used to find signals in the record (wave, trace, log,..) file and convert them into a plot that can be shown in the Plot Area.
Inside of a view you find Plots to display the signal data and Folders to organize the presentation in a hierarchical structure. This enables the user to hide/show parts of the presentation.
The CSV Reader requires a configuration (CSV Configuration) to work. A configuration contains information about the char set, the delimiter, labels and and the actual data fields.
From the menu bar click on "Window" from the submenu chose "Preferences" a box will open, there click on "Impulse" from the left hand side menu. Then click on "Serializer" and choose "CSV Data and Log (CSV)", double click it, there will pop a window with already configurations. On the right side, there will be a button "Add" by clicking it you can add your configurations, so, click on it.
Now you are on CSV Configuration form.
The next section is about the data columns, here you will choose the data types. Data types should be according to the type of field. Leave the first type as none, the second field is for 'delay' so choose integer data type, the third field is for received so, it should also be an integer, and the remaining 2 should be float.
The last section is Domain value choose the values as follows:
Mark the checkbox below to enable relative domain values and press the OK button.
Again click on OK and then on APPLY, hence the configuration is completed.
Now, it’s time to show the data.
Now you have successfully shown the data in a view.