If the source data has fixed-width columns, the first element of each two-element array specifies the starting character position in the column (as an integer 0 (zero) is the first character). This example causes the third column to be skipped, the first column to be parsed as text, and the remaining columns in the source data to be parsed with the General setting. If a given column specifier is not present for a particular column in the input data, the column is parsed with the General setting. The column specifiers can be in any order. The first element is the column number (1-based), and the second element is one of the constants specifying how the column is parsed. 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 interpretation depends on the value of DataType. An array containing parse information for the individual columns of data. If more than one character is specified, only the first character of the string is used the remaining characters are ignored.įieldInfo - Optional Variant. The delimiter character when Other is True. OtherChar - Optional Variant (required if Other is True). True to have DataType be xlDelimited and to have the character specified by the OtherChar argument be a delimiter. True to have DataType be xlDelimited and to have the space character be a delimiter.
True to have DataType be xlDelimited and to have the comma be a delimiter. The default value is False.Ĭomma - Optional Variant. True to have DataType be xlDelimited and to have the semicolon be a delimiter. True to have DataType be xlDelimited and to have the tab character be a delimiter. True to have Microsoft Excel consider consecutive delimiters as one delimiter. If the range is larger than a single cell, the top left cell is used.ĬonsecutiveDelimiter - Optional Variant. A Range object that specifies where Microsoft Excel will place the results. TextQualifier:= xlTextQualifier.xlTextQualifierDoubleQuote, _ĭestination - Optional Variant. Parses a column of cells that contain text into several columns.ĭataType:= xlTextParsingType.xlDemilited, _