remove leading zeros with transform

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
wjl11
Posts: 3
Joined: Tue Oct 10, 2017 12:44 pm

remove leading zeros with transform

Post by wjl11 » Thu Mar 27, 2008 12:56 pm

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?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> remove leading zeros with transform

Post by kfleming » Mon Mar 31, 2008 9:39 am

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

Post Reply