Kbase P15560: TRIM function doesn't work in Report Builder.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/29/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
TRIM function doesn't work in Report Builder.
TRIM function doesn't remove characters at different locations of the string.
CAUSE:
The Trim function removes leading and trailing characters but it won't remove unwanted characters that appear in the middle of the string.
FIX:
Use the REPLACE function to remove characters that appear in the middle of the string.
REPLACE(source-string, from-string, to-string)