TextToColumns(Int32,Int32,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( _
   Optional ByVal row As Integer, _
   Optional ByVal column As Integer, _
   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 row As Integer
Dim column As Integer
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(row, column, dataType, textQualifier, consecutiveDelimiter, tab, semicolon, comma, space, other, otherChar, fieldInfo, decimalSeparator, thousandsSeparator, trailingMinusNumbers)

ActionResult<object> TextToColumns( 
   int row,
   int column,
   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

row
column
dataType
textQualifier
consecutiveDelimiter
tab
semicolon
comma
space
other
otherChar
fieldInfo
decimalSeparator
thousandsSeparator
trailingMinusNumbers

Reference

IRange Interface
IRange Members
Overload List