2.5.41 ECTxtWizData
The ECTxtWizData record specifies text importation properties common for BrtBeginECTxtWiz (section 2.4.69) and BrtBeginECTxtWiz15 (section 2.4.70) records.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
iCpidNew |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
reserved2 |
|||||||||||||||||||
|
chCustom |
rowStartAt |
||||||||||||||||||||||||||||||
|
... |
chDecimal |
chThousSep |
|||||||||||||||||||||||||||||
A - iCpid (2 bits): An unsigned integer that specifies the type of character set to use during importation. This value MUST be one of the values in the following table.
-
Value
Meaning
0x00
Macintosh
0x01
Windows (ANSI)
0x02
MS-DOS (PC-8)
The value of iCpid is used to determine the code page associated with the text file if iCpidNew is less than 3, otherwise iCpidNew is used.
iCpidNew (10 bits): An unsigned integer that specifies application-specific code page information that exists for text importation purposes.
B - fDelimited (1 bit): A bit that specifies whether the file is tab or character delimited. If the value is 0, then fTab, fSpace, fComma, fSemiColon, fCustom, and chCustom MUST be ignored. The following table specifies the meaning of each value.
-
Value
Meaning
0
The file is parsed according to fixed length fields.
1
The file is tab or character delimited.
C - fTab (1 bit): A bit that specifies whether tabs are used as field delimiters.
D - fSpace (1 bit): A bit that specifies whether space characters are used as field delimiters.
E - fComma (1 bit): A bit that specifies whether comma characters are used as field delimiters.
F - fSemiColon (1 bit): A bit that specifies whether semicolon characters are used as field delimiters.
G - fConsecutive (1 bit): A bit that specifies whether consecutive delimiters are treated as just one delimiter.
H - fTextDelim (2 bits): An unsigned integer that specifies the character used as the text string qualifier. The following table specifies the meaning of each value.
-
Value
Meaning
0x00
Double Quote
0x01
Single Quote
0x02
None
0x03
None
I - reserved1 (1 bit): MUST be 1 and MUST be ignored
J - fPromptForFile (1 bit): A bit that specifies whether the user selected to receive a prompt for the file name on refresh. This value MUST be 1 if the length of the string specified by stFile is equal to 0 characters.<65>
K - fCustom (1 bit): A bit that specifies whether the custom delimiter character chCustom is used as a field delimiter.
reserved2 (9 bits): This value MUST be 0, and MUST be ignored.
chCustom (2 bytes): An unsigned integer that specifies the Unicode character to be treated as a field delimiter.
rowStartAt (4 bytes): An unsigned integer that specifies at what row of the file to start the data importation. This value MUST be greater than 0 and less than 100000000.
chDecimal (1 byte): An unsigned integer that specifies the decimal separator character in ISO-8859-1 [ISO-8859-1] encoding.
chThousSep (1 byte): An unsigned integer that specifies the thousands separator character in ISO-8859-1 [ISO-8859-1] encoding.