Deprecated. Don't use for new development and try to migrate existing uses.

Type: Table-valued function

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.


@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.