TRIM(expression,@VM,'T') I have not tested this but I believe the above will remove all trailing @VM characters. leaving any embedded ones.
> -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: Tuesday, 1 February 2011 6:30 a.m. > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > If the field were just a VM, trim would have left it there. > > I didn't reject TRIM, I just didn't consider it (and not vehemently). > > In general, I use TRIM to eliminate extras and CHANGE/CONVERT to > eliminate ALL > > Since the original questions was to get rid of all the VM's I went with > CHANGE/CONVERT > > > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann > > Sent: Monday, January 31, 2011 11:58 AM > > To: U2 Users List > > Subject: Re: [U2] How to Clear Empty VM marks in Field > > > > George, > > > > why do you so vehemently reject the TRIM or TRIMB solutions? > > I think it is the cleanest offered so far and requires the least > > coding. > > > > just my 2 pence > > > > Mecki > > > > On 31/01/2011 16:33, George Gallen wrote: > > > 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 > > > > > _______________________________________________ > > 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 > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users