Mecki, Thanks, Ultimatly it's probably the only way to do it. It does sort of surprise me, given the general power and years of use of U2 dictionaries, there isn't a way to remove or filter MV values inline.
Thanks all, I'll just go with a sub =) Jake -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 9:39 AM To: [email protected] Subject: Re: [U2] Remove items from lsit in DICT Jake TRANS will return the raw data, so I'd write a little Basic subroutine, compile and catalog it globally and use SUBR( to call it in the dict. You either loop trough the array and delete the unwanted values or you could use SWAP and end up with a 6 liner like this. SUBROUTINE GETREP(RET.VALUE,ARRAY) SWAPSTRING = 'B':@VM SWAP SWAPSTRING WITH '' IN ARRAY SWAP 'B' WITH '' IN ARRAY RET.VALUE = ARRAY RETURN I haven't used SWAP with @VM so I won't guarantee that it'll work and you might have to use LOOP or FOR NEXT in your subroutine after all. So in the end your line 2 in your DICT item would look something like this: SUBR("GETREP",TRANS("FILE",F1,1,"X")) Sometimes it's just the easiest way and in my experience quite fast too. Mecki On 06/04/2012 14:48, Holt, Jake wrote: > I need to do it from a dictionary item: > 1: I > 2: Trans("FILE",F1,1,"X");<remove the Bs from @1> > > Basically I am trying to remove our house rep account from the list of > rep numbers when I trans them to the sales order file. > > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Mecki > Foerthmann > Sent: Friday, April 06, 2012 4:05 AM > To: U2 Users List > Subject: Re: [U2] Remove items from lsit in DICT > > You could try selecting BY-EXP dictname # "B" > > On 05/04/2012 23:05, Holt, Jake wrote: >> This is probably really simple, but I can't seem to find a way >> without writing a sub. Is there an easy way to simply remove items >> from a MV field in a dictionary? >> >> >> >> For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to >> just remove the Bs. >> >> >> >> Thanks, >> >> >> >> Jake Holt | samsill | Information Technology Director >> (p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 >> >> [email protected]<mailto:[email protected]> | www.samsill.com | >> www.bindersforlife.com >> >> >> >> _______________________________________________ >> 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
