Sets the string that is to be used to separate fields.
Applies To
-
Dataports
-
XMLports
Property Value
| Value | Description |
|---|---|
|
<None> |
There is no field separator |
|
<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 can also be mixed with other characters.
The default value is a comma (<,>).
CR refers to the character with ASCII value 13.
LF refers to the character with ASCII value 10.
FieldSeparator is only used if the FileFormat Property is set to Variable. Otherwise, the setting is ignored.
See Also
© 2010 Microsoft Corporation. All rights reserved.