Sets the string that is to be used to mark the start of a field.
Applies To
Dataports
Property Value
Value | Description |
---|---|
<None> |
There is no FieldStartDelimiter |
<NewLine> |
Any combination of CR and LF characters |
<CR/LF> |
CR followed by LF |
<CR> |
CR alone |
<LF> |
LF alone |
<TAB> |
Tabulator alone |
Other strings |
The literal string entered |
Remarks
The strings in the preceding table must be entered literally, using the < and > characters. These special strings can be combined, and also be mixed with other characters.
The default is " (a quote).
CR refers to the character with ASCII value 13.
LF refers to the character with ASCII value 10.
FieldStartDelimiter is only used if the FileFormat Property is Variable. Otherwise, the setting is ignored.
The string defined as FieldStartDelimiter is used in addition to the string defined as the FieldSeparator Property. Use this in situations where the fields include characters that are themselves delimiters. If it is not necessary to use FieldStartDelimiter for this purpose, set it to a value of <None>.
When importing, the delimiters can be present in the file. The following example shows what would happen if FieldStartDelimiter and FieldEndDelimiter are equal to " and FieldSeparator is equal to ,.
a,"b",c,"text with comma,",d
The result would be broken into fields like this:
a
b
c
text with comma,
d
See Also
© 2010 Microsoft Corporation. All rights reserved.