Reporting Language > Character Functions > SQUEEZ: Reducing Multiple Spaces to a Single Space

SQUEEZ: Reducing Multiple Spaces to a Single Space

How to:

The SQUEEZ function reduces multiple contiguous spaces within a character string to a single space. The resulting character string has the same length as the original string but is padded on the right with spaces.

Syntax: How to Reduce Multiple Spaces to a Single Space 

SQUEEZ(length, source_string, output)

where:

length

Integer

Is the number of characters in source_string and output.

source_string

Alphanumeric

Is the character string to squeeze.

output

Alphanumeric

Example: Reducing Multiple Spaces to a Single Space

WebFOCUS

Feedback