CSVTORANGE

Returns a range which has been extracted from a CSV (comma separated version) text.

Syntax

CSVTORANGE(csvText; columnDelimiter; rowDelimiter; option)

• csvText - the csv text which should be converted to a range - Value type: text

• columnDelimiter - the character which separates cell values column-wise - Value type: text (optional, default value: “;”)

• rowDelimiter - the character which separates cell values row-wise - Value type: text (optional, default value: empty)

• option - option to escape delimiters in the cell values - Value type: constant (optional, default value: noescaping) Possible values are:

  1. noescaping - delimiter characters in cell values are not converted

  2. escaping - delimiter characters in cell values are converted (see remarks)

Remarks

1. To apply special characters like tab, carriage return or line feed, use the function CHAR for the delimiters (see example below).

2. If option is escaping, the delimiter characters are escaped (converted) in the following way:

   1. all double quotes of all texts in range are automatically replaced with two double quotes.

   2. if a cell value contains one of the two delimiters or a double quote.

   3. the cell value is automatically enclosed with double quotes.

Examples