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: [email protected] [mailto:u2-users- > [email protected]] 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: [email protected] [mailto:u2-users- > >> [email protected]] 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 > >> [email protected] > >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > > 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
