Field List for Matching Settings
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|||
|---|---|---|---|---|---|---|---|
|
Format |
The format of the icon placed in the input area. |
CSV, Format, Excel, Database Table |
No |
|
|||
|
Comment |
|
Characters |
Yes |
255 bytes or fewer |
|||
|
Layout (Common) |
|||||||
|
|
ID (#15) |
|
Alphanumeric characters and symbols (#1) |
No |
50 bytes or fewer |
||
|
File name (#2) |
|
Windows |
Characters (#3) |
No |
200 bytes or fewer |
||
|
UNIX |
Alphanumeric characters and symbols (#4) |
||||||
|
Layout (CSV) |
|||||||
|
|
Omit ID |
OFF |
ON, OFF |
No |
|
||
|
Delimiter |
, |
(,), ! #, $, %, &, (, ), ^, |, ~, \, $TAB, $SPACE, $NULL, Enter hexadecimal value |
Yes |
You can specify settings when the Omit ID is selected. |
|||
|
Delimiter (hexadecimal) |
|
Hexadecimal character |
*1 |
||||
|
Enclosure character |
" |
", #, $, %, &, ', (, ), ^, |, ~, \, $TAB, $SPACE, None, Enter hexadecimal value |
Yes |
||||
|
Enclosure character (hexadecimal) |
|
Hexadecimal character |
*1 |
||||
|
Check number of fields |
OFF (#5) |
ON, OFF |
No |
You can specify settings when the Omit ID is not selected. |
|||
|
Use header record |
OFF |
ON, OFF |
No |
|
|||
|
Number of rows for the header record |
|
1 to 99 |
*2 |
|
|||
|
Code conversion |
|||||||
|
|
Kanji code (#6) |
(#7) |
Shift JIS, JEF, EUC, IBM kanji, KEIS, NEC kanji, UTF-16, UTF-8, JIS |
No |
|
||
|
Unicode byte order (#6) (#8) |
Same as host |
Same as host, Big-endian, Little-endian |
No |
|
|||
|
EBCDIC set (#6) (#9) |
EBCDIC kana |
EBCDIC kana, EBCDIC lowercase, EBCDIC ASCII, EBCDIC ASPEN, Japan (Latin) for IBM, Japan (Latin) Extended for IBM, NEC Katakana, Japan (Katakana) Extended for IBM, ASCII (#10) |
No |
|
|||
|
Line break code (#11) |
(#12) |
Hexadecimal character |
No |
Displayed for CSV. UTF-16: 4, or 8 bytes Other than UTF-16: 2, or 4 bytes |
|||
|
Key settings |
|||||||
|
|
Handling of multiple keys |
Return an error |
Generate an error, Do not generate an error |
No |
|
||
|
Keys are unique |
OFF |
ON, OFF |
No |
|
|||
|
Handling of no keys |
Return an error |
Generate an error, Do not generate an error |
No |
|
|||
|
Default setting value list |
|||||||
|
|
No. |
|
Display only |
|
|
||
|
Field No. |
|
Display only |
|
|
|||
|
Field name (#13) |
|
Display only |
|
|
|||
|
Input type |
Character string |
Character string, Character string (Hexadecimal) |
Yes |
|
|||
|
Default value |
|
Input type / Character string: Characters (#3) |
No |
9999 bytes or fewer |
|||
|
Input type / Character string (Hexadecimal): Hexadecimal character (#14) |
No |
2 to 9998 digits or fewer |
|||||
|
Operation settings |
|||||||
|
|
Expansion method |
Expand to memory |
Expand to memory, Expand to a file |
No |
|
||
|
Handling of trailing spaces after character data |
Do not trim |
Trim, Do not trim |
No |
|
|||
|
#1 |
: |
You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()). |
|
#2 |
: |
If Format is Database Table, you cannot use this field. |
|
#3 |
: |
External characters cannot be used. Operations are not guaranteed if you use any platform-dependent characters. |
|
#4 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&). |
|
#5 |
: |
Initial value if Format is CSV with ID specified. |
|
#6 |
: |
In the case of DataMagic Desktop grade, this is displayed but cannot be changed. |
|
#7 |
: |
The value of Encoding of input and output files (cs4file) specified in the system environment settings file (huledenv.conf) is applied. Note that when the format is set to CSV or Database Table, if Encoding of input and output files (cs4file) is set to a character encoding that cannot be initially displayed (encoding other than the open standard character encodings, Shift JIS, EUC, UTF-8, and UTF-16), the value of Local host kanji code type (knjcode) is used. |
|
#8 |
: |
This is displayed if UTF-16 is selected as the kanji code. |
|
#9 |
: |
This is displayed if JEF, IBM kanji, KEIS, NEC kanji, or JIS is selected as the kanji code. |
|
#10 |
: |
You can select this if JIS is specified in the kanji code type. |
|
#11 |
: |
You can specify this field only if Format is CSV. |
|
#12 |
: |
The initial value for the line break code depends on the OS where DataMagic Server runs. In DataMagic Desktop grade, the value is 0D0A. |
|
#13 |
: |
If Format is CSV and no ID is specified, this field is not displayed. |
|
#14 |
: |
You can use only A, B, C, D, E, and F as alphabetic characters. |
|
#15 |
: |
You can omit this field if Format is CSV. |
|
*1 |
: |
Input is required if Enter hexadecimal value has been selected for Delimiter or Enclosure character. |
|
*2 |
: |
Input is required if the Use header record is selected. |