CSV Input Format

Log Parser

CSV Input Format

The CSV input format parses comma-separated values text files.

CSV text files are generated and handled by a large number of applications and tools, including:

  • Microsoft Excel
  • PerfMon
  • Generic spreadsheet applications

In a CSV text file, each line consists of one record, and fields in a record are separated by commas.
Depending on the application, the first line in a CSV file might be a "header", containing the labels of the record fields.
The following example shows a CSV file beginning with a header:

DateTime, PID, Comment
5/28/2004 13:56:12, 2956, Application started
5/28/2004 13:59:02, 2956, Waiting for input
5/28/2004 14:12:45, 3104, Application started
5/28/2004 15:24:42, 1048, Application started
Moreover, field values and labels might be enclosed within double-quote (") characters, as shown by the following PerfMon CSV log file example:
"\\GAB1\Processor(_Total)\% Processor Time","\\GAB1\System\Processes"
"99.999993086289507","33"
"2.0000000000000018","33"
"1.0000000000000009","33"
"0.33333333333332993","33"
"0.33333333333332993","33"
"0","33"
"4.0000000000000036","33"
"4.3333333333333339","33"


From-Entity Syntax
Fields
Parameters
Examples


See also:

TSV Input Format
CSV Output Format


© 2004 Microsoft Corporation. All rights reserved.