CSV Data to List

This function extracts CSV data from a named variable and produces a list in a named variable. Each item in the produced list represents a row of CSV data. Rows are separated by the row delimiter. Each produced row is also a list which contains the column data for a row. Column items are separated by the column delimiter.

If the row delimiter resolves to be empty when the action is executed, a default (\~) will be assumed. If the column delimiter is empty, \, sequence is assumed.

All text fields may contain any of the escape sequences described in Escape Sequences.

Some tips:

• If the CSV data contains a header row, it will become the first extracted row.
• Entirely empty lines are ignored.
• Take care in using \n as a delimiter. It is entirely valid for CSV data to contain embedded newline characters.

This function is only performed once while executing stepwise.

See List to CSV Data to convert list data to CSV data.