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.
Note:
Currently only rows with a maximum of 20 columns/fields are supported.
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.