COMPRESS Function
Description: Compresses the white space out of a string.
Parameters: String, Boolean
- Source Text: The input string to trim and/or compress the spaces from.
- Trim: True to trim and compress the spaces from input text. False to only compress the spaces from input text.
Return: A string consisting of the characters specified with extra white space removed.
Syntax: COMPRESS(<source text>,<trim>)
Example: Remove white space from the value of the “Location” data element. For a source string value of “New York”, the resulting string would become “New York”.
COMPRESS( DE(“Location”).getValue( ), True);
{{export-indexterm primary="COMPRESS function"/}}
{{export-indexterm primary="COMPRESS function"/}}
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*