Jake,
Try
TRANS("FILE",F1,1,"X");IFS(NES(@,REUSE('B')),@,REUSE(''));TRIM(@,@SM)
Cheers,
Andy
________________________________
From: "Holt, Jake" <[email protected]>
To: U2 Users List <[email protected]>
Sent: Friday, 6 April 2012, 14:48
Subject: Re: [U2] Remove items from lsit in DICT
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
