ADMIN_Csv_ParseText

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

Type: Stored procedure

Parses a comma-separated-values file in nvarchar format.

The columns may be separated by any separator you specify, and values may optionally be quoted with double-quotes.

Use ADMIN_Csv_ParseFile if you need to parse varbinary data.

Parameters

@ColumnCount mandatory int
How many columns the data contains.

If less than the actual number of columns in the data then then an error will occur.

If greater than the actual number of columns in the data then performance will suffer.
@Separator optional nchar(1)
Value that separates columns/fields. The default is semi-colon (;)
@Text mandatory nvarchar(max)
The text to parse.