Comma-Separated (CSV)

The CSV refiner processes CSV formatted text. The following example assumes the user is attaching a refiner to a remote exec task and that "Format" is set to "Comma Separated". When a similar configuration dialog is presented in other places, the same information applies.

When "Read and process task output" is checked, a refiner will be executed after a task runs.

Variable

The variable provided is assigned to the resulting object. The format of the resulting object after parsing:

x,y
10,20
30,40

is as follows:

{
    "columns": [
        "x",
        "y"
    ],
    "totalRows": 2,
    "data": [
        [ 10, 20 ],
        [ 30, 40 ]
    ]
}

Character Encoding

The character encoding of the data to process or "Let Situate decide". Input text is converted to UTF-8 for processing in situate.

Header Rows

The header rows spinner sets the number of header rows. If more than one header row is set, the value placed in the "columns" string will be each column concatenated together and separated with a newline.

Field and Quote

The "Field Separator" can be specified and is a comma by default. The "Quote Character" can also be specified.