<textPr>
(Text Import Settings)
This element contains all of the text import settings.
Here's an example of the XML for a text connection:
<connection id="1" name="text data" type="6" refreshedVersion="3" background="1" saveData="1"> <textPr prompt="0" codePage="437" sourceFile="C:\Desktop\text data.txt" delimiter="|"> <textFields count="5"> <textField/> <textField type="text" position="7"/> <textField type="text" position="28"/> <textField position="36"/> <textField type="text" position="41"/> </textFields> </textPr> </connection>
Parent Elements |
---|
|
Child Elements |
Subclause |
---|---|
|
Attributes |
Description |
||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Code page associated with the text file.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
||||||||||||||||||||||||||||||||||||
|
Flag indicating whether to treat comma characters as field delimiters. The possible values for this attribute are defined by the XML Schema boolean datatype. |
||||||||||||||||||||||||||||||||||||
|
Flag indicating whether consecutive delimiters should be treated as just one delimiter. If this flag is The possible values for this attribute are defined by the XML Schema boolean datatype. |
||||||||||||||||||||||||||||||||||||
|
The decimal separator character. This and the The following table shows the results when you import text into a spreadsheet application using various separators. Numeric results are displayed in the rightmost column.
Strings values of this attribute are expected to be one character in length. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
||||||||||||||||||||||||||||||||||||
|
The possible values for this attribute are defined by the XML Schema boolean datatype. |
||||||||||||||||||||||||||||||||||||
|
User-specified character to be treated as a field delimiter. Only single characters are supported. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
||||||||||||||||||||||||||||||||||||
|
Ignorable attribute with enum value that equals either "Macintosh," "Windows (ANSI)," or "MS-DOS (PC-8)" (see the definition of ST_FileType) and determines the kind of character set to use during import. Only one of The possible values for this attribute are defined by the ST_FileType simple type (§3.18.30). |
||||||||||||||||||||||||||||||||||||
|
Indicates at what row of the file to start the data import. All unsignedInt values are valid, although it's possible that firstRow will be higher than the number of rows in the text file, in which case no data will be imported. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
||||||||||||||||||||||||||||||||||||
|
Flag indicating whether the user wants to be prompted for the file name on refresh. If The possible values for this attribute are defined by the XML Schema boolean datatype. |
||||||||||||||||||||||||||||||||||||
|
Character used as the text string qualifier. The possible values for this attribute are defined by the ST_Qualifier simple type (§3.18.63). |
||||||||||||||||||||||||||||||||||||
|
Flag indicating whether to treat semicolon characters as field delimiters. The possible values for this attribute are defined by the XML Schema boolean datatype. |
||||||||||||||||||||||||||||||||||||
|
Path to the text file to use to import external data. May be expressed in URI or system-specific file path notation. |
||||||||||||||||||||||||||||||||||||
|
Flag indicating whether to treat space characters as field delimiters. The possible values for this attribute are defined by the XML Schema boolean datatype. |
||||||||||||||||||||||||||||||||||||
|
Flag indicating whether to treat tab characters as field delimiters. If The possible values for this attribute are defined by the XML Schema boolean datatype. |
||||||||||||||||||||||||||||||||||||
|
The thousands separator character. This and the Strings values of this attribute are expected to be one character in length. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_TextPr">
<sequence>
<element name="textFields" minOccurs="0" maxOccurs="1" type="CT_TextFields"/>
</sequence>
<attribute name="prompt" use="optional" type="xsd:boolean" default="true"/>
<attribute name="fileType" use="optional" type="ST_FileType" default="win"/>
<attribute name="codePage" use="optional" type="xsd:unsignedInt" default="1252"/>
<attribute name="firstRow" use="optional" type="xsd:unsignedInt" default="1"/>
<attribute name="sourceFile" use="optional" type="ST_Xstring" default=""/>
<attribute name="delimited" use="optional" type="xsd:boolean" default="true"/>
<attribute name="decimal" use="optional" type="ST_Xstring" default="."/>
<attribute name="thousands" use="optional" type="ST_Xstring" default=","/>
<attribute name="tab" use="optional" type="xsd:boolean" default="true"/>
<attribute name="space" use="optional" type="xsd:boolean" default="false"/>
<attribute name="comma" use="optional" type="xsd:boolean" default="false"/>
<attribute name="semicolon" use="optional" type="xsd:boolean" default="false"/>
<attribute name="consecutive" use="optional" type="xsd:boolean" default="false"/>
<attribute name="qualifier" use="optional" type="ST_Qualifier" default="doubleQuote"/>
<attribute name="delimiter" use="optional" type="ST_Xstring"/>
</complexType>