This property sets the field separation character in the text file floating field specification.
Syntax
object.FieldDelimiter = string
object
This specifies object expressions that define references to objects.
string
This specifies the field separation characters.
Description
This sets the field separation characters in text file floating field specification.
When each field is specified in floating field format, the field separation characters that define delimitation of the field in the record can be specified. When this specification is omitted, blanks and tabs are assumed to be field separation characters.
Specify field separation characters in character strings or the hexadecimal numbers.
To specify character string, enclose the whole strings with quotation marks ('). Specify backslash (\) before quotation marks (') when a quotation mark (') is assumed to be a separator. Also, when backslash (\) is assumed to be a field separation character, specify successive 2 backslash (\).
To specify field separation characters in the hexadecimal numbers, put x in the head and proceed with hexadecimal codes. The code that cannot be input as a character such as tabs can be specified.
The same character as the record separator cannot be specified. The record separator is specified in the LineDelimiter property.
Note
As for the field number of floating field, the heading field is 0.
When the specification of field separation characters is omitted, the heading blank or tab in the record is included in the heading field. When any blanks or tabs in other than heading of the record are successive, the first blank is a field separation character and the rest of the blanks are part of the field.
It is considered that the null field exists between 2 separators when field separation characters are specified and the field separation character exists successively. The field separation character is not included in the field.
Example
Example when field separation character is specified by character string
A blank | ' ' |
A backslash (\) | '\\' |
Blank and quotation mark (') | ' \'' |
Example when field separation character is specified by hexadecimal number
Specification of tab | x09 |
