Thanks to all that replied. I had coded the array loop looking for nulls and decrementing the counter. Now, I am trying Colin's reply of: FXI = TRIM(FXI,@VM) which looks to work during my initial testing.
Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jeffrey Butera Sent: Monday, January 31, 2011 8: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 [email protected] 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
