Exporting to CSV
To export an Angle to CSV format
Execute the Angle (see Executing an Angle or Template ). The Angle results page opens.
Find the Display in the Displays pane . If there are many Displays, the Display tab of the Display might not be immediately visible. In that case, click
to see the list of available Displays and find your Display there.
Click
to open the wizard.
-
Fill the following fields:
File name - Specify the name for your CSV file. The Angle name is shown by default.
-
File options
Header rows - Select whether you want to include the ID, the short name or the long name in the column headers of the CSV file. If you have defined an alternative name for a field, the alternative name will be shown in the CSV file.
Use text qualifier on headers - Specify whether you want to apply a text qualifier to the headers in the export. A text qualifier is a symbol indicating where text begins and ends, for instance ".
Use text qualifier - Select the type of field on which you want to apply a text qualifier in the export.
Text qualifier - Enter the text qualifier you wish to use (" in the image above).
Field delimiter - Enter your field delimiter (, in the image above).
Line delimiter - Select your line separator: CRLF (Windows), LF (Unix) and CR (Macintosh).
-
Format options
Date separator - Enter the character that you would like to use to format the date. This character separates year, month, and day.
Date format - Specify how you would like to format dates. In this example a resulting date could be 2016/05/31.
Time separator - Enter the character that you would like to use to format the time. This character separates hours, minutes, and seconds.
Time format - Specify how you would like to format time. In this example a resulting timestamp could be 12:23.
Decimal separator - Enter the character that you would like to use as a decimal separator.
Decimals - Select the number of decimals you would like to export. Leave this field blank to export all decimals.
Yes/No character - Enter the characters you would like to use for boolean values (yes/no, true/false, 1/0, etc.).
Set format - Specify how you would like to see possible values. Example: If you select ID, the Execution status 'closed' will be shown as 'es2FullyExecuted'. If you select Display, it will be shown as 'closed'.
Insert model timestamp - Select the column in which you want to add the model date to each record in the export.
Click OK to start the export. By default, the CSV file will be saved in your Downloads folder.