The output format for all commands corresponds to the following rules:
Each record is output in a separate line. A record contains all the information to be displayed on an object.
The first line is a header and contains the field names of the respective columns. Only the field names are guaranteed, not the order of fields in the record. In other words, the order of columns is determined by the order of the field names in the header line.
Two tables, with their own respective headers, are output sequentially for the command SHOW-FTAC-ENVIRONMENT. If one of the tables is empty, the corresponding header is also dropped.
Individual fields within an output line are delimited by a semicolon “;”.
The following data types are differentiated in the output:
Number
Integer
String
Since ";" is a metacharacter in the CSV output, any text that contains ";" is enclosed in double quotes ("). Double quotes within a text field are doubled in order to differentiate them from text delimiters. When imported into a program, the doubled quotes are automatically removed and the text delimiters removed. Keywords are output in uppercase with a leading asterisk (*) and are not enclosed in double quotes.
Date
The date and time are output in the form yyyy-mm-dd hh:mm:ss. In some cases, only the short form yyyy-mm-dd is ouput, i.e. the date alone.
Time
The time is output in the form yyyy-mm-dd hh:mm:ss or only hh:mm:ss.