Extreme Optimization™: Complexity made simple.

Math and Statistics
Libraries for .NET

  • Home
  • Features
    • Math Library
    • Vector and Matrix Library
    • Statistics Library
    • Performance
    • Usability
  • Documentation
    • Introduction
    • Math Library User's Guide
    • Vector and Matrix Library User's Guide
    • Data Analysis Library User's Guide
    • Statistics Library User's Guide
    • Reference
  • Resources
    • Downloads
    • QuickStart Samples
    • Sample Applications
    • Frequently Asked Questions
    • Technical Support
  • Order
  • Company
    • About us
    • Testimonials
    • Customers
    • Press Releases
    • Careers
    • Partners
    • Contact us
Introduction
Deployment Guide
Nuget packages
Configuration
Using Parallelism
Expand Mathematics Library User's GuideMathematics Library User's Guide
Expand Vector and Matrix Library User's GuideVector and Matrix Library User's Guide
Expand Data Analysis Library User's GuideData Analysis Library User's Guide
Expand Statistics Library User's GuideStatistics Library User's Guide
Expand Data Access Library User's GuideData Access Library User's Guide
Expand ReferenceReference

Skip Navigation LinksHome»Documentation»Reference»Extreme.Data.Text»DelimitedTextOptions Class»DelimitedTextOptions Constructors»DelimitedTextOptions Constructor (IFormatProvider, Boolean, Boolean, Int32, Int32, Type, Char, String, QuoteUsage, Char, QuoteEscapeMethod, Char, Boolean, AutoCategorization, Int32)

DelimitedTextOptions Constructor (IFormatProvider, Boolean, Boolean, Int32, Int32, Type, Char, String, QuoteUsage, Char, QuoteEscapeMethod, Char, Boolean, AutoCategorization, Int32)

Extreme Optimization Numerical Libraries for .NET Professional
Constructs a new set of options for delimited text files.

Namespace:  Extreme.Data.Text
Assembly:  Extreme.Data (in Extreme.Data.dll) Version: 3.1.0
Syntax

C#
VB
C++
F#
Copy
public DelimitedTextOptions(
	IFormatProvider formatProvider = null,
	bool rowHeaders = false,
	bool columnHeaders = true,
	int startRow = 0,
	int inferenceRows = 100,
	Type decimalType = null,
	char columnDelimiter = ',',
	string endOfLine = "",
	QuoteUsage quote = QuoteUsage.AsNeededForColumnType,
	char quoteCharacter = '"',
	QuoteEscapeMethod quoteEscapeMethod = QuoteEscapeMethod.Double,
	char escapeCharacter = '\',
	bool mergeConsecutiveDelimiters = false,
	AutoCategorization autoCategorize = AutoCategorization.None,
	int maxCategories = 100
)
Public Sub New ( 
	Optional formatProvider As IFormatProvider = Nothing,
	Optional rowHeaders As Boolean = false,
	Optional columnHeaders As Boolean = true,
	Optional startRow As Integer = 0,
	Optional inferenceRows As Integer = 100,
	Optional decimalType As Type = Nothing,
	Optional columnDelimiter As Char = ","C,
	Optional endOfLine As String = "",
	Optional quote As QuoteUsage = QuoteUsage.AsNeededForColumnType,
	Optional quoteCharacter As Char = """C,
	Optional quoteEscapeMethod As QuoteEscapeMethod = QuoteEscapeMethod.Double,
	Optional escapeCharacter As Char = "\"C,
	Optional mergeConsecutiveDelimiters As Boolean = false,
	Optional autoCategorize As AutoCategorization = AutoCategorization.None,
	Optional maxCategories As Integer = 100
)
public:
DelimitedTextOptions(
	IFormatProvider^ formatProvider = nullptr, 
	bool rowHeaders = false, 
	bool columnHeaders = true, 
	int startRow = 0, 
	int inferenceRows = 100, 
	Type^ decimalType = nullptr, 
	wchar_t columnDelimiter = L',', 
	String^ endOfLine = L"", 
	QuoteUsage quote = QuoteUsage::AsNeededForColumnType, 
	wchar_t quoteCharacter = L'"', 
	QuoteEscapeMethod quoteEscapeMethod = QuoteEscapeMethod::Double, 
	wchar_t escapeCharacter = L'\', 
	bool mergeConsecutiveDelimiters = false, 
	AutoCategorization autoCategorize = AutoCategorization::None, 
	int maxCategories = 100
)
new : 
        ?formatProvider : IFormatProvider * 
        ?rowHeaders : bool * 
        ?columnHeaders : bool * 
        ?startRow : int * 
        ?inferenceRows : int * 
        ?decimalType : Type * 
        ?columnDelimiter : char * 
        ?endOfLine : string * 
        ?quote : QuoteUsage * 
        ?quoteCharacter : char * 
        ?quoteEscapeMethod : QuoteEscapeMethod * 
        ?escapeCharacter : char * 
        ?mergeConsecutiveDelimiters : bool * 
        ?autoCategorize : AutoCategorization * 
        ?maxCategories : int 
(* Defaults:
        let _formatProvider = defaultArg formatProvider null
        let _rowHeaders = defaultArg rowHeaders false
        let _columnHeaders = defaultArg columnHeaders true
        let _startRow = defaultArg startRow 0
        let _inferenceRows = defaultArg inferenceRows 100
        let _decimalType = defaultArg decimalType null
        let _columnDelimiter = defaultArg columnDelimiter ','
        let _endOfLine = defaultArg endOfLine ""
        let _quote = defaultArg quote QuoteUsage.AsNeededForColumnType
        let _quoteCharacter = defaultArg quoteCharacter '"'
        let _quoteEscapeMethod = defaultArg quoteEscapeMethod QuoteEscapeMethod.Double
        let _escapeCharacter = defaultArg escapeCharacter '\'
        let _mergeConsecutiveDelimiters = defaultArg mergeConsecutiveDelimiters false
        let _autoCategorize = defaultArg autoCategorize AutoCategorization.None
        let _maxCategories = defaultArg maxCategories 100
*)
-> DelimitedTextOptions

Parameters

formatProvider (Optional)
Type: SystemIFormatProvider
An IFormatProvider that is used in the conversion between text and other data types.
rowHeaders (Optional)
Type: SystemBoolean
Indicates that the first column contains row headers.
columnHeaders (Optional)
Type: SystemBoolean
Indicates that the first row contains column headers.
startRow (Optional)
Type: SystemInt32
An integer specifying the 1-based row which contains the start of the data.
inferenceRows (Optional)
Type: SystemInt32
The number of rows to use to infer the types of the columns.
decimalType (Optional)
Type: SystemType
The type to use for numbers containing decimals.
columnDelimiter (Optional)
Type: SystemChar
The character used to separate columns.
endOfLine (Optional)
Type: SystemString
The string used to terminate a row.
quote (Optional)
Type: Extreme.Data.TextQuoteUsage
A QuoteUsage value that specifies when fields should be quoted. The default is AsNeededForColumnType.
quoteCharacter (Optional)
Type: SystemChar
The character used to quote fields.
quoteEscapeMethod (Optional)
Type: Extreme.Data.TextQuoteEscapeMethod
Specifies whether the quote character should be repeated twice when it appears in quoted text.
escapeCharacter (Optional)
Type: SystemChar
The character to use to escape quote characters.
mergeConsecutiveDelimiters (Optional)
Type: SystemBoolean
Indicates whether consecutive column delimiters are to be treated as a single delimiter.
autoCategorize (Optional)
Type: Extreme.DataAutoCategorization
Specifies which columns should be automatically converted to categorical columns.
maxCategories (Optional)
Type: SystemInt32
The largest number of distinct levels for a column to be considered categorical.
Exceptions

ExceptionCondition
ArgumentOutOfRangeExceptionstartRow is less than 1.
See Also

Reference

DelimitedTextOptions Class
DelimitedTextOptions Overload
Extreme.Data.Text Namespace

Copyright (c) 2004-2023 ExoAnalytics Inc.

Send comments on this topic to support@extremeoptimization.com

Copyright © 2004-2023, Extreme Optimization. All rights reserved.
Extreme Optimization, Complexity made simple, M#, and M Sharp are trademarks of ExoAnalytics Inc.
Microsoft, Visual C#, Visual Basic, Visual Studio, Visual Studio.NET, and the Optimized for Visual Studio logo
are registered trademarks of Microsoft Corporation.