Mapping information (output format)

(1) Fields for Output format settings

Output format

Select the field type of the output format.

Table 2.47 Field Type and Output Format Matrix

Field type

Standard

Date

Numeric character string

Character string

9

Yes

No

No

No

B

Yes

No

No

No

F

Yes

No

No

No

I

Yes

No

No

No

M

Yes

Yes

Yes

Yes

N

Yes

No

No

Yes

P

Yes

No

No

No

S

Yes

No

No

No

X

Yes

Yes

Yes

Yes

D

Yes

Yes

No

No

Z

Yes

No

Yes

No

W

Yes

No

No

No

CSV character string

Yes

Yes

Yes

Yes

CSV numeric value

Yes

No

Yes

No

XML character string

Yes

Yes

Yes

Yes

XML numeric value

Yes

No

Yes

No

: The format can be specified

: Format cannot be specified

= Remarks =

  • If Numeric character string is selected as the output format,

  • When you specify an output format of a date character string for a field of type D in an Excel file, the output result differs as follows depending on whether the specified format is a format that DataMagic can interpret as a date.

    Specified output format

    Template

    Output result

    Interpretable as date

    Example) YYYY/MM/DD

    Used

    Character strings for dates are converted to serial numbers. When displayed in Excel,

    the dates are displayed in the format specified in the template file.

    Interpretable as date

    Example) YYYY/MM/DD

    Not used

    Character strings for dates are converted to serial numbers.

    Not interpretable as date

    Example) HH:MI:SS

    Used

    An error occurs on conversion. all characters are output in halfwidth even when Convert halfwidth to fullwidth is selected for Alphanumeric conversion in Fullwidth and halfwidth character conversion.

    Not interpretable as date

    Example) HH:MI:SS

    Not used

    Character strings are output in the specified output format.

  • When you specify an output format of a numeric character string for a field of type Z in an Excel file, the output result differs as follows depending on whether Use a template is selected in the Excel - Detailed Information screen.

    Specified output format

    Template

    Output result

    Digit delimiter: Not specified

    and

    Currency symbol: Not specified

    Used

    Numeric character strings are converted to real numbers.

    When displayed in Excel, the numbers are displayed in the format specified in the template file.

    Digit delimiter: Not specified

    and

    Currency symbol: Not specified

    Not used

    Numeric character strings are converted to real numbers.

    Digit delimiter: Specified

    or

    Currency symbol: '\' or '$'

    Used

    An error occurs on conversion.

    Digit delimiter: Specified

    or

    Currency symbol: '\' or '$'

    Not used

    Character strings are output in the specified output format.

 

Standard

The output is generated as is without specifying the format.

= Remarks =

When the standard format is specified as D in Field type, the output is generated in the format YYYY/MM/DD.

Dates

Format

Specify the output format for the date.The following character string will be converted to the corresponding value. All other characters are displayed as is without conversion.

= Remarks =

  • If Field type is X, you cannot specify EE, EEYY, eeyy, or 2-byte codes.

  • For DataMagic to support a Japanese era name that is more recent than 平成, it is necessary to specify the new Japanese era name in the Japanese era name (era_name) field of the system environment settings file (huledenv.conf).

YYYY

: Western calendar year (four digits)

YY

: Western calendar year (last two digits)

E

: Abbreviated form of Japanese era name (M, T, S, H)

EE

: Japanese era name (明治, 大正, 昭和, 平成)

EYY

: Abbreviated form of Japanese era name and Japanese calendar year (for example, T09 and S25)

EEYY

: Japanese era name and Japanese calendar year (for example, 大正09 and 昭和25)

eyy

: Abbreviated form of Japanese era name and Japanese calendar year (for example T9 and S25)

eeyy

: Japanese era name and Japanese calendar year (for example 大正9 and 昭和25)

MM

: Month (01 to 12)

mm

: Month (1 to 12)

DD

: Day (01 to 31)

dd

: Day (1 to 31)

HH

: Hour (00 to 23)

hh

: Hour (0 to 23)

MI

: Minute (00 to 59)

mi

: Minute (0 to 59)

SS

: Second (00 to 59)

ss

: Second (0 to 59)

HH24

: Hour (00 to 23)

hh24

: Hour (0 to 23)

HH12

: Hour (01 to 12)

hh12

: Hour (1 to 12)

AM

: AM or PM

Am

: Am or Pm

am

: am or pm

A.M.

: A.M. or P.M.

a.m.

: a.m. or p.m.

MON

: Abbreviation of a month (all uppercase)

Mon

: Abbreviation of a month (initial letter uppercase)

mon

: Abbreviation of a month (all lowercase)

MONTH

: Month (all uppercase)

Month

: Month (initial letter uppercase)

month

: Month (all lowercase)

Samples

A sample of the output format for the date. Double-click to set the selected value as the format.

  • YYYY/MM/DD HH:MI:SS

  • YYYY-MM-DD HH:MI:SS

  • YYYY-MM-DD

  • MON DD YYYY

  • MONTH DD YYYY

  • MM.DD.YYYY HH12:MI:SS AM

Handling of null characters

Specify the conversion method of Null (0 bytes) in the input data.

Execution start date

: Converts the null value to the execution start date.

Null

: Converts the null value to the same null value.

Note

  • If the data is output as type D, you cannot specify this field.

  • If the data is output to a database, and when Null is specified in Handling of 0-byte input data in the Output Settings screen, the null value is converted to the same null value regardless of this field setting value.

Numeric character string

Sign output

Select to output the sign or not.

Add to negative values only

: A minus sign (-) is added to a negative value. A sign is not added to a positive value.

Add nothing (absolute value)

: Outputs the numeric value's absolute value without adding a sign.

Add to both positive and negative values

: A plus sign (+) is added to a positive value, and a minus sign (-) is added to a negative value.

Significant digits after dec. pt.

Specify whether to specify the digits after decimal point in the output.

Custom

: Specify the number of digits after decimal point. Specify a value from 0 to 9. Values that exceed the specified number of digits are processed according to the settings in Handling of insignificant digits.

Undefined

: The number of digits after the decimal point is not specified. All decimal places are output.

Note

If the decimal part of the calculation result exceeds 9 digits, the exceeded part will be truncated.

Handling of insignificant digits

Select the rounding method when the numeric value's decimal part exceeds the value set for Significant digits after dec. pt. in the output format.

Round to the nearest value (up for 5 and above)

: The value is rounded to the nearest value (up for 5 and above).

Round up

: The value is rounded up.

Round down

: The value is rounded down.

Digit delimiter

Specify whether to put a comma separator every 3 digits (as in 10,000,000).

Add

: The value is output with a comma separator every 3 digits.

Do not add

: The value is output without separators.

Note
  • When output is generated as CSV, type Z values are handled as character data if Digit delimiter is set to Add. Therefore, if an Enclosure character is specified in the output CSV information (when a CSVID is specified) or the data processing information output settings (when a CSVID is omitted), that enclosure character is added to the output.
  • When output is generated as XML, if the element type is numeric data, Digit delimiter is set to Do not add, and you cannot edit it.

Currency symbol

Specify whether to add a currency unit.

Undefined

: A currency unit is not added.

\

: A backslash (\) is added as the currency unit.

$

: A dollar sign ($) is added as the currency unit.

Note

When output is generated as XML, if the element type is numeric data, Currency symbol is set to Undefined, and you cannot edit it.

Padding method

Specify the padding method when the character string size after formatting is larger than the set value for Padding size in the output format.

Left-justified

: The output generated is left-justified.

Right-justified and padded with zeros (0)

: The output generated is right-justified, and the left side is padded with zeros.

Right-justified and padded with spaces

: The output generated is right-justified and the left padding is a space.

Padding size

Specify the minimum value of the output size. When the character string is smaller than the set value for Padding size after formatting, it is padded up to the specified size according to the Padding method setting. When the character string size is larger after formatting, all of it is output without trimming.

You can specify this either if Format for the output is CSV or XML, or if the output field is set to Variable length.

Custom

: The padding size is specified.

Undefined

: The padding size is not specified.

Handling of null characters

Specify the conversion method of Null (0 bytes) in the input data.

Treat as zero (0)

: The null value is converted to 0.

Null

: The null value is handled as is.

Note

  • If the data is output as type Z, you cannot specify this field.

  • If the data is output to a database, and when Null is specified in Handling of 0-byte input data in the Output Settings screen, the null value is converted to the same null value regardless of this field setting value.

  • When output is generated as XML, if the element type is numeric data, Handling of null characters is set to Treat as zero (0), and you cannot edit it.

Character string

Output method

Specify the padding method when the character string size after formatting is larger than the set value for Padding size in the output format.

Left-justified

: The output generated is left-justified.

Right-justified

: The output generated is right-justified.

If the output size is not specified, leading spaces are trimmed for left-justified, and trailing spaces are trimmed for right-justified.

Figure 2.1 Example of leading and trailing space trimming

Output size

Specify the output size. Specify this as a numeric value from 1 to 99,999.

You can specify this for variable-length fields.

For fixed length fields, this is reflected in Output size when No. of bytes is selected for Field information (output) in the Set Mapping Information screen.

Undefined

: The size is not specified.

Custom

: The size is specified.

Note

  • When Format is CSV or XML, this setting is enabled even if Trim is selected for the Handling of trailing spaces after character data in the output settings.

  • Padding for type N use fullwidth spaces. Padding for other types use halfwidth spaces.

    KEIS encoding fullwidth spaces use 0xA1A1 regardless of the setting in KEIS fullwidth space in the output settings.

  • When the output location is a variable length field, the output data size is determined according to the input data character size and the size specified in Output size.

    When the input data character string size is smaller than the value set for Output size, the padding will be up to the specified size. When the input data character string size is larger, the entire character string is output regardless of the setting of Output size.

  • When the output location is a fixed length field, and the output data is larger than the specified output size, it might be trimmed.

    Figure 2.2 Example of character trimming