Show all Hide all


Performs generic parsing of a single row from a standard CSV-file including full support for the "double quote"-escape mechanism.

Currently only rows with a maximum of 20 columns/fields are supported.

Type: Table-valued function
Area of use: General use


@Row mandatory nvarchar(max)
The CSV-row to parse.
@Separator mandatory nvarchar(300)
The column/field separator to use.
@TrimUnescapedWhitespace optional bit
Specifies whether leading and trailing whitespace in a field that is not within semi-colon should be trimmed. By default no whitespace is trimmed.