split_csv

The split_csv function is used to split a text string containing comma-separated values into separate values. You can use this function to split up lines taken from a CSV file.

 split_csv ( csv; list )

The function has two parameters:

  1. csv, type TEXT; contains the comma-separated values text string that needs to be split.
  2. list, type ARRAY TEXT; contains the ARRAY where the separate values are stored.

The result of the function is of type NUMBER. This is the number of elements that were extracted from the text string comma-separated values. If an empty text string is passed as the parameter csv, the result is1, and the parameter list contains one element that is empty.