TRIM Function
Description: Removes leading and trailing spaces and whitespace from the string. Multiple consecutive spaces between words will not be trimmed to a single space.
Parameters: String
- Source text: The string containing the source value.
Return: String containing the trimmed value.
Syntax: TRIM (<source text>)
Example: Set the value of String 7 trim to the value of String 7 after the dropping leading and trailing spaces and nulls.
DE("String 7 trim").setValue
( TRIM( DE("String 7").getValue( ) ) ) ;
{{export-indexterm primary="TRIM function"/}}
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*