TSV Output Format Parameters

Log Parser

previous page next page

TSV Output Format Parameters

The TSV output format supports the following parameters:

headers
  Values: ON | OFF | AUTO
  Default: AUTO
  Description: Write a header line containing the field names.
  Details: This parameter controls the header line that is output at the beginning of each file.
The possible values for this parameter are:
  • ON: always write the header;
  • OFF: never write the header;
  • AUTO: write the header only when not appending to an existing file.
  Example: -headers:OFF
 
oSeparator
  Values: any string | space | tab
  Default: tab
  Description: Separator between fields.
  Details: This parameter controls the separator to be used between field values.
The "tab" keyword causes the TSV output format to use a single tab character between the fields, while the "space" keyword causes the TSV output format to use a single space character.
  Example: -oSeparator:space
 
oTsFormat
  Values: timestamp format
  Default: yyyy-MM-dd hh:mm:ss
  Description: Format of timestamp values in the output TSV data.
  Details: This parameter specifies the date and/or time format to use when formatting values of the TIMESTAMP data type.
For more information on date and time formats, see Timestamp Format Specifiers.
  Example: -oTsFormat:"MMM dd, yyyy"
 
oCodepage
  Values: codepage ID (number)
  Default: 0
  Description: Codepage of the output text.
  Details: 0 is the system codepage, -1 is UNICODE.
  Example: -oCodepage:1245
 
fileMode
  Values: 0 | 1 | 2
  Default: 1
  Description: Action to perform when an output file already exists.
  Details: This parameter controls the behavior of the TSV output format when the into-entity specifies directly or indirectly through the "multiplex" feature the name of a file that already exists.
The possible values for this parameter are:
  • 0: existing files are appended with the output;
  • 1: existing files are overwritten with the output;
  • 2: existing files are left intact, discarding the output.
  Example: -fileMode:0
 

© 2004 Microsoft Corporation. All rights reserved.

previous page start next page