New Line for CSV/Fixed-length

For files that contain data in CSV or fixed-length format, the structure of the data is essentially determined by the data that forms one line.

In Lobster_data there is a node attribute Line break, which determines whether a new line should be started after the node has been processed. If this property has the value Yes, the mapper works as follows.

• After processing the node, a new line is started.

• If the node contains output fields before a subnode with a line break, then the associated output fields and subnodes are placed in one line.

• If the node contains output fields after a subnode with a line break, the associated output fields are placed in a new line.

If attribute Line break has the value No, there will be no new line created after a node is exited. The following screenshot shows the effects when the Line break attribute has value No for both a node and a subnode.

(1) Attribute Line break of node node has the value No.

(2) Attribute Line break of node Subnode also has the value No.

(3) With those settings, all fields will be written in one line.

The next screenshot shows the effects if the Line break attribute for document type CSV/Fixed-length has value Yes for a node and value No for a subnode.

(1) Attribute Line break of node node has the value Yes. Therefore, a line feed is executed after exiting the node in the destination tree.

(2) Attribute Line break of node Subnode also has the value No.

(3) With those settings, all fields will be written in one line. A line feed is executed after exiting the node.

(4) The values of the subsequent node will be written in one line and a line feed will be executed after that.

The next screenshot shows the effects if the Line break attribute for document type CSV/Fixed-length has value No for a node and value Yes for a subnode.

(1) Attribute Line break of node node has the value No.

(2) Attribute Line break of node Subnode has the value Yes. Therefore, after exiting the node in the destination tree, a line feed is executed.

(3) All values of the fields will be written in one line.

(4) All values of the fields (and also those of the subsequent node) will be written in one line.

(5) After exiting the node Subnode a line feed is executed.

(6) The value of the field will be written in one line.

The last screenshot shows the effects if the Line break attribute for document type CSV/Fixed-length has value Yes for a node and for a subnode.

(1) Attribute Line break of node node has the value Yes. Therefore, after exiting the node in the destination tree, a line feed is executed.

(2) Attribute Line break of node Subnode has the value Yes. Therefore, after exiting the node in the destination tree, a line feed is executed.

(3) The values of the fields will be written in one line. After exiting node Subnode a line feed is executed.

(4) The values of the fields will be written in one line. After exiting node node a line feed is executed.