Output Fixed - 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

Writes data to a fixed-width file using designated field positions. The field specification consists of colon (:) separated field entries. Each field entry is of the form: name,start position,size.

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

Properties

File

Click the folder icon and browse to the file to which you want to output 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.

FieldPositions

Specify a colon-separated field specification. Each entry is of the form: name,start position,size.

For example: FirstName,0,10:LastName,10,20:Salary,30,10.

A value is required for this property.

RecordDelimiter

Optionally specify a string or character that will separate consecutive rows or records in the output file.

Use \n for newline (Unix style), \r\n for carriage return newline (Windows style).

The default value is blank, in which case there will be no delimiter used, only the record width.

WriteHeader

Optionally specify whether to write a single record header row of the field names (truncated to field width if necessary).

The default value is False.

RecordWidth

Optionally specify the size of each record in bytes.

If unspecified, the record will be as long as the largest (start+size) specification in the FieldPositions.

Padding

Optionally specify a byte value used to pad data in fields that are not long enough for their specification. Use \<octal> notation to specify non-printable characters, for example, \0 is NUL, \40 is space.

The default value is \0.

NullValue

Optionally specify what to output when the value of a field is NULL.

The default value is blank.

LongField

Optionally specify the behavior if the data in a field is longer than the field specification. Choose from:

  • Truncate - Truncates the field.
  • Truncate and Log - Truncates the field and records this action in the log file.
  • Error - An error is generated.

The default value is Truncate.

Inputs and outputs

Inputs: in1.

Outputs: None.