LEADINGSPACES subcommand (GET DATA command)

For TYPE=XLS, XLSX, XLSM, and TXT, LEADINGSPACES controls the treatment of blank spaces at the start of string values.

• For TYPE=TXT, this subcommand applies only to ARRANGEMENT=DELIMITED.
• For TYPE=TXT, if a blank space is specified as a delimiter on the DELIMITERS subcommand, this subcommand only affects string values enclosed in specified QUALIFIER values.

IGNORE=NO

Blank spaces at the start of string values are included in the value. This is the default setting.

IGNORE=YES

Blank spaces at the start of string values are removed.