The only problem will be if there are multivalued data elements by eliminating the VM's, it will combine into one big element.
Maybe a subroutine to scan the string first to make sure there is only one element, then do the elimination (by whatever method). ex. 0001: one^253two^253^253 will become 0001: onetwo George > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > Sent: Monday, January 31, 2011 11:03 AM > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > 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 > > > > _______________________________________________ > 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