ADMIN_Csv_ParseText

 Show all Hide all

Deprecated.

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.

Type: Stored procedure
Area of use: General use

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.