format delimited
Icon |
|
|---|---|
Use When |
Model based data needs to be formatted into delimited text |
Samples |
Relational Database to Flat File |
Description |
The format delimited component takes a model based message and formats its content into a delimited text message |
Inbound Message Type |
Model Based Message |
Output Message Type |
Text Based Message |
Control Message Handling |
Input: As entity messages are received this component will process the data. Output: A single control message will be forwarded to downstream components once all messages have been processed through this step. |
| Name | Description |
|---|---|
Whether to forward failed messages and continue processing. This is the name of a linked component to forward the failed messages to. |
|
Delimiter |
The character that should be used to delimit the attribute values |
Quote Character |
The character that should be used to quote the attribute values that are of type String |
Header line |
Whether a header line should be created that contains attribute column names |
Trim Columns |
Whether to trim the data before it is formatted and forwarded |
Double clicking on the Format delimited component in the flow will result in the Format Delimited editor being displayed as shown below.
The editor displays a row for every entity and attribute in the input model, and allows setting the ordinal position of each for the delimited output. Order the attributes in the order in which they should be displayed in the delimited result. Attributes can be ordered by:
-
Selecting an attribute and dragging it up or down in the list
-
Selecting an attribute clicking the "Move Up", "Move Down", "Move Top" or "Move Botton" buttons
-
Selecting an attribute or set of attributes, clicking "Cut" to remove them and then "Pasting them elsewhere in the list
In addition to specifying the order of the attributes in the delimited list, transform functions can also be applied to each attribute. These transform functions are good for applying formatting, etc.