'Declaration
 
Overloads Function TextToColumns( _
   ByVal destination As String, _
   Optional ByVal dataType As TextParsingType, _
   Optional ByVal textQualifier As TextQualifier, _
   Optional ByVal consecutiveDelimiter As Boolean, _
   Optional ByVal tab As Boolean, _
   Optional ByVal semicolon As Boolean, _
   Optional ByVal comma As Boolean, _
   Optional ByVal space As Boolean, _
   Optional ByVal other As Boolean, _
   Optional ByVal otherChar As Char, _
   Optional ByVal fieldInfo() As Tuple(Of Integer,ColumnDataType), _
   Optional ByVal decimalSeparator As Char, _
   Optional ByVal thousandsSeparator As Char, _
   Optional ByVal trailingMinusNumbers As Boolean _
) As ActionResult(Of Object)

'Usage
 
Dim instance As IRange
Dim destination As String
Dim dataType As TextParsingType
Dim textQualifier As TextQualifier
Dim consecutiveDelimiter As Boolean
Dim tab As Boolean
Dim semicolon As Boolean
Dim comma As Boolean
Dim space As Boolean
Dim other As Boolean
Dim otherChar As Char
Dim fieldInfo() As Tuple(Of Integer,ColumnDataType)
Dim decimalSeparator As Char
Dim thousandsSeparator As Char
Dim trailingMinusNumbers As Boolean
Dim value As ActionResult(Of Object)
 
value = instance.TextToColumns(destination, dataType, textQualifier, consecutiveDelimiter, tab, semicolon, comma, space, other, otherChar, fieldInfo, decimalSeparator, thousandsSeparator, trailingMinusNumbers)

ActionResult<object> TextToColumns( 
   string destination,
   TextParsingType dataType,
   TextQualifier textQualifier,
   bool consecutiveDelimiter,
   bool tab,
   bool semicolon,
   bool comma,
   bool space,
   bool other,
   char otherChar,
   Tuple<int,ColumnDataType>[] fieldInfo,
   char decimalSeparator,
   char thousandsSeparator,
   bool trailingMinusNumbers
)

Parameters

destination

A string value that specifies where Spread will place the results. If the range is larger than a single cell, the top left cell is used.

dataType

The format of the text to be split into columns.

textQualifier

Specifies whether to use single, double, or no quotes as the text qualifier.

consecutiveDelimiter

true to have Spread consider consecutive delimiters as one delimiter.

tab

true to have dataType be TextParsingType.Delimited and to have the tab character be a delimiter.

semicolon

true to have dataType be TextParsingType.Delimited and to have the semicolon character be a delimiter.

comma

true to have dataType be TextParsingType.Delimited and to have the comma character be a delimiter.

space

true to have dataType be TextParsingType.Delimited and to have the space character be a delimiter.

other

true to have dataType be TextParsingType.Delimited and to have the otherChar character be a delimiter.

otherChar

Required if other is true; the delimiter character when other is true. If more than one character is specified, only the first character of the string is used; the remaining characters are ignored.

fieldInfo

An array containing parse information for the individual columns of data. The interpretation depends on the value of dataType. When the data is delimited, this argument is an array of two-element arrays, with each two-element array specifying the conversion options for a particular column. The first element is the column number, and the second element is one of the ColumnDataType constants specifying how the column is parsed.

decimalSeparator

The decimal separator that Spread uses when recognizing numbers. The default setting is the system setting.

thousandsSeparator

The thousands separator that Spread uses when recognizing numbers. The default setting is the system setting.

trailingMinusNumbers

Numbers that begin with a minus character.

Return Value

Reference

IRange Interface
IRange Members
Overload List