Would TRIM not work? VAL=TRIM(VAL,@VM)
Support: James F Thompson Senior Systems Analyst Cypress Business Solutions 678.494.9353 supp...@cypressesolutions.com -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, January 31, 2011 11:27 AM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field On 01/31/11 11:02, Steve Romanow wrote: > I like George's solution. > > On 1/31/2011 9:12 AM, George Gallen wrote: >> Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not >> do the job? >> or FXI=CHANGE(FXI,CHAR(253),"") >> >> Maybe: >> >> EQU CLEARVM TO CONVERT CHAR(253) TO "" IN >> ... >> ... >> ... >> CLEARVM FXI This would work if your data was a single non-null field with numerous null values. But if your list had more than a single non-null value this would be bad. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users