CHK_LENB function

Functions

CHK_LENB{[MIN_SIZE], [MAX_SIZE], TRUE_STRING, FALSE_STRING }

This function checks whether the length of the character string data exceeds the maximum length, and returns a specified character string.

Parameters

MIN_SIZE

Specify the minimum value of the character string length. Use a number from 1 to 99999. If you omit MIN_SIZE, this check is not performed.

MAX_SIZE

Specify the maximum value of the character string length. Use a number from 1 to 99999. If you omit MAX_SIZE, this check is not performed.

TRUE_STRING

Specify the character string to be returned if the length is within the range of specified values. (This parameter cannot be omitted.)

FALSE_STRING

Specify the character string to be returned if the length is outside the range of specified values. (This parameter cannot be omitted.)

= Remarks =

  • You cannot omit both MAX_SIZE and MIN_SIZE.

  • To specify a specific character string length, set the same value in MAX_SIZE and MIN_SIZE.

Example

1. CHK_LENB{3,5,True,False}

Figure A.1 Example of using the CHK_LENB function (1)

2. CHK_LENB{,5,OK,NG}

Figure A.2 Example of using the CHK_LENB function (2)

3. CHK_LENB{5,5,OK,NG}

Figure A.3 Example of using the CHK_LENB function (3)