-
Notifications
You must be signed in to change notification settings - Fork 82
parse fixed
Icon |
|
---|---|
Use When |
An inbound text message in a fixed length text format needs to be parsed into a model based message structure |
Samples |
|
Description |
The parse fixed length component takes an inbound text message in fixed length format and parses it into a model based outbound message. |
Inbound Message Type |
Text Based Message |
Output Message Type |
Model Based Message |
Control Message Handling |
Input: As text messages are received they are processed. 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. |
|
Number of Header Lines to Skip |
The number of header lines that should be skipped and not sent to downstream components |
Number of Footer Lines to Skip |
The number of footer lines that should be skipped and not sent to downstream components |
Trim Parsed Columns |
Whether to trim the data after it has been parsed |
Double clicking on the Parse Fixed component in the flow will result in the Parse Fixed editor being displayed as shown below.
The editor displays a row for every entity and attribute in the output model, and allows setting the ordinal position and width of each attribute for the fixed length 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
Set the width by typing the width in to the Width field. Start and end positions are automatically calculated based on the order and width.
In addition to specifying the order and width of the attributes, transform functions can also be applied to each attribute. These transform functions are good for applying formatting, etc.