TextToColumns(IRange,TextParsingType,TextQualifier,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Char,Tuple<Int32,ColumnDataType>[],Char,Char,Boolean) Method

In This Topic

Syntax

Visual Basic
C#

'Declaration
 
Overloads Function TextToColumns( _
   ByVal destination As IRange, _
   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 IRange
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( 
   IRange 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
dataType
textQualifier
consecutiveDelimiter
tab
semicolon
comma
space
other
otherChar
fieldInfo
decimalSeparator
thousandsSeparator
trailingMinusNumbers

Reference

IRange Interface
IRange Members
Overload List