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