Kbase 18464: Report Builder - How to Remove Zeroes From String Field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/05/2002 |
|
Status: Unverified
GOAL:
How to Remove Zeroes From String Field
FACT(s) (Environment):
Report Builder
FIX:
1) Create a calculated field (calc1) with the following the expression:
STRING(cust-num)
The result for cust-num 1 will be 1.00000
2) To remove the zeroes, use the following instead in the expression:
STRING(cust-num, ">>>>>>9")