FW: Extracting sales rep from Sales Rep ID list

Yahoo Archive
1
See http://www.tek-tips.com/faqs.cfm?fid=2364

There's this function, parse_str, which you can call like this:

Parse_str("~", 3, ttOrderHed.SalesRepCode)

That would give you the third one.

I assume you can include a function in the main body of your code in
Vantage? I'm wondering if you can put this in a file somewhere in the
PROPATH in such a way you could call these functions from any custom
code?

-brian

# This function searches string for an instance of char_delim
# starting at position cnt and returns the string ending at the next
# char_delim or the end of string
######################################################################
function parse_str(char_delim, cnt, string)
######################################################################

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Friday, August 20, 2010 11:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] FW: Extracting sales rep from Sales Rep ID list

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.

Apologize if this ends up as a double post. The first time I tried it
did not make it through to the board.

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]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
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.

Apologize if this ends up as a double post. The first time I tried it did not make it through to the board.

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]