Page 1 of 1
remove leading zeros with transform
Posted: Thu Mar 27, 2008 12:56 pm
by wjl11
hello,____trying to wrap a positive number with parens and at the same time trim any spaces and zeros.____transform(GLNUMBER,"(999999.99)")__returns ( 123.45)____how do I get rid of the spaces?
=> remove leading zeros with transform
Posted: Mon Mar 31, 2008 9:39 am
by kfleming
Why not just add the parentheses as literal text on the layout and format the numeric field as fixed and use autotrim to close the space instead of using transform?____Kathleen__R&R Support