Extracting sales rep from Sales Rep ID list

Hi Thom,

> I think someone has mentioned this before, but I can't find it. The sales rep ID's are stored in a single field in the system, thus: REP1~REP2~REP3~REP4~REP5. If I want to extract the nth rep code from the list, is there a simple formula I can use in a BAQ or in 4GL? I'm thinking something like Extract(RepList,3) would return REP3.
>

Check out the ABL INDEX and LOOKUP functions.

Mark W.
I think someone has mentioned this before, but I can't find it. The sales rep ID's are stored in a single field in the system, thus: REP1~REP2~REP3~REP4~REP5. If I want to extract the nth rep code from the list, is there a simple formula I can use in a BAQ or in 4GL? I'm thinking something like Extract(RepList,3) would return REP3.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>



[Non-text portions of this message have been removed]