CsvSourceOptions.ValueSeparator Property

Gets or sets a character used to separate values in a CSV document.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v19.1.dll

Declaration

C#

[DefaultValue(',')]
public char ValueSeparator { get; set; }

VB.NET

<DefaultValue(","c)>
Public Property ValueSeparator As Char

Property Value

Type	Default	Description
Char	','	A Char value that specifies the character used to separate values in a CSV document.

Remarks

Use the CsvSourceOptions.DetectValueSeparator property to specify whether the character used to separate values in a CSV document is determined automatically.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ValueSeparator property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

snap-how-to-customize-the-data-explorer-panel-t535534/CS/CustomDataExplorer/Form1.cs#L61

csvSourceOptions.DetectNewlineType = true;
csvSourceOptions.ValueSeparator = '\t';
excelDataSource.SourceOptions = csvSourceOptions;