Output Delimited - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

Outputs data to a delimited text file using designated delimiters for fields and records.

CAUTION:
This node has been deprecated and will not be supported in a future release. As an alternative, the Output CSV/Delimited node can be used to provide similar functionality.

To configure this node:

  1. In the File property, click the folder icon and browse to the file to which you want to export the data, then click Choose. To create a new file, click the folder icon and navigate to the folder where you want to output the file, then enter a name for the file in the Filename field and click Choose.
  2. Specify how the field names should be formatted in the output by selecting one of the following options from the FieldNames property:
    • None - The output does not include a header line.
    • Name - Outputs a header row of field names.
    • Name:Type - Outputs a header row that includes the field name and the data type.

    The default value is Name.

  3. In the FieldDelimiter property, specify the field delimiters. The field delimiter is the character sequence that is used to separate the fields in the file, for example:
    • \t Separates the fields by tabs (default).
    • , Separates the fields by commas.
    • | Separates the fields by pipes.
    • \\ Separates the fields by a single backslash.
  4. In the RecordDelimiter property, specify the record delimiters. The record delimiter is the character sequence that is used to separate consecutive records in the output file, for example:
    • \r\n Places each row of data into separate (multiple) rows.
    • \n Places each row of data onto a new line (default).
    • \t Separates the records by tabs.
    • \\ Separates the records by a single backslash.

Properties

File

Click the folder icon and browse to the file to which you want to export the data, then click Choose.

To create a new file, click the folder icon and navigate to the folder where you want to output the file, then enter a name for the file in the Filename field and click Choose.

A value is required for this property.

Note: If you are using the server edition, the output file will be created on the Data360 Analyze server. If you wish to open the file, and you don't have access to the file system on the server, you will need to download the file onto your local machine. Please see the topic Downloading data from the server for more details.

FieldNames

Optionally specify how the field names should be formatted in the output. Choose from:
  • None - The output does not include a header line.
  • Name - Outputs a header row of field names.
  • Name:Type - Outputs a header row that includes the field name and the data type.
The default value is Name.

FieldDelimiter

Optionally specify the field delimiters. The field delimiter is the character sequence that is used to separate the fields in the file.

The default value is \t, which separates the fields by tabs.

RecordDelimiter

Optionally specify the record delimiters. The record delimiter is the character sequence that is used to separate consecutive records in the output file.

The default value is \n, which places each row of data onto a new line.

EscapeCharacter

Optionally specify the escape character which will be used to precede literal EscapeCharacters or QuoteCharacters appearing within data fields. If no EscapeCharacter is specified, a doubled QuoteCharacter will be used to escape a literal QuoteCharacter in the data (as is done in CSV format). Unlike the delimiters, this character should not be preceded with a backslash.

QuoteCharacter

Optionally specify the quote character which will be used to surround fields in the data otherwise containing RecordDelimiters, FieldDelimiters, or QuoteCharacters. Unlike the delimiters, this character should not be preceded with a backslash.

The default value is the double quote character (").

DoubleQuote

Optionally specify whether, when the quote character appears in the field, the character is doubled. If set to false, the EscapeCharacter must be defined, and it will be used instead.

The default value is True.

WhenToQuote

Optionally specify when quoting should occur. Choose from:

  • All - All fields will be quoted.
  • Minimal - Only fields that contain the delimiter or begin with the quote character will be quoted.
  • NonNumeric - All non-numeric fields will be quoted.
  • None - Use the escape character given instead of quoting (the EscapeCharacter property must be defined).

The default value is Minimal.

NullValue

Optionally specify the value to be output when the field is NULL.

The default value is blank.

Inputs and outputs

Inputs: in1.

Outputs: None.