Preparing an export file

Copy a template file stored in the provided media or the download module to any folder as an export file.

Table B.1 Common components templates

Common components ID

Description

SAISON_BEFORE_DATE

Returns TRUE if the input date is earlier than the execution date for data processing, and returns FALSE if that is not the case.

SAISON_CHECKLEN

Checks whether the input string length is within the specified number. Returns an empty string for normal, and an error message for exceed. Multibyte characters and variant characters are also counted as one character.

 

The output error message is as follows:

[Error Message]

The maximum number of characters for item ("Argument2") is "Argument1", but "Number of characters in input data" characters have been entered: Input data ("Input data")

*The red text will be replaced with the corresponding data and output.

SAISON_DATE_CHECK

Returns TRUE if the input character string is in the date format YYYY/MM/DD, and returns FALSE if that is not the case.

SAISON_M10W21

Calculates check digits using modulus 10 with 2:1 weighting.

SAISON_PAD

The specified character string is repeatedly padded until it reaches the specified size.

SAISON_REPLACE_REG

This is an extended version of REPLACE_REG. The replace string can be specified as a hexadecimal string (\xHH).

SAISON_STRLEN

Gets the number of characters in the input string. Multibyte characters are counted as one character. Variant characters are also counted as one character.

SAISON_SUBSTR

Obtains a string with a specified number of characters from an input character string starting from a specified position.

SAISON_TOLOWER

Converts uppercase characters of the input character string to lowercase.

SAISON_TOUPPER

Converts lowercase characters of the input character string to uppercase.