Trim Field

This will change the leading or trailing spaces in an A type field to binary 0s.

TRIM fn/v

trim_what

TRAIL - Trim trailing characters. This is the default option.

LEAD - Trim leading characters.

COMMENTS

When you use the function TRIM() the program puts the trimmed field in the temporary data space. If you are trying to TRIM a field that is larger than that space you will get the message that the program is out of room in the temporary data area. This command is provided to you so that you can TRIM a field larger than the temporary data area within its own space. Using this command you will not run out of memory.

NOTE: This command will NOT work with CodeBase fields. You must use the TRIM() function.

EXAMPLE

TRIM BKAR.CUSTCODE //This would trim the trailing Char in the fld.