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
