ADMIN_ParseCSVRow

 Show all Hide all

Deprecated.

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

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

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

Parameters:

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