Function Block CSV_DECODE

The Function Block CSV_DECODE decodes a line of a CSV string.

Note: This function block can have more than one output. You can right-click on the function block to add another output.

Input CSV

The input expects a string in CSV format.

Input DELIMITER

The input defines the character between columns. If the input is equal to NULL, then ";" is assumed.

Input ENCLOSURE

Defines the brackets of values. If the input is equal to NULL, then """ is assumed.

Input ESCAPE

Defines the escape character. An empty string disables the proprietary masking mechanism. If the input is equal to NULL, then "\" is assumed.

Note: Normally, an enclosure character in a cell is masked by doubling it. However, the escape character can be used alternatively. Thus, by default, the values "" and "\" have the same meaning. Apart from the possibility to mask the enclosure character by the escape character, the latter has no special significance. It is not even suitable for masking itself.

Outputs VALUE1..VALUE#

An output returns the extracted data of the column. If the column does not exist, the value NULL is returned.