BLANKS( ) function

Returns a string containing a specified number of blank spaces.

Syntax

BLANKS(count)

Parameters

count

Numeric. The number of blank spaces to insert.

Output

Character.

Remarks

This function creates a blank character string of the specified length. It can be used harmonize fields, initialize variables in scripts, or to insert blank spaces when formatting fields or concatenating strings.

Examples

Example Return value

BLANKS(5)

“     “

“ACL” + BLANKS(1) + “Services”

“ACL Services”



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback