How about function|substr(userName0, strstr(userName0, "\") + 1)
That should take the substring from just after the position of the "\" to the end of the string, which should just be the login ID. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Christopher Gillman Sent: Wednesday, July 01, 2009 12:01 PM To: [email protected] Subject: Re: nested function question with EIE ** Oops, correction, I indicated using the right function... I meant the left function. On Wed, Jul 1, 2009 at 12:49 PM, Christopher Gillman <[email protected]<mailto:[email protected]>> wrote: Hi all, It's been a LONG time since I've posted anything to the ol' ARSList, so I thought I'd give this a shot. I'm using EIE to retrieve a field containing login information from a third-party SQL database. The database captures this information in a format similar to: "XXXXX-XXX\username" What I really want is just the information after the "\". The number of characters in front of the "\" isn't always the same. Sometimes it's more, sometimes it's less. What I'm wonering is... is there any way to do some kind of nested function to return this? I was thinking along the lines of using the "strstr()" function and the "right()" function, but i'm not confident that this will work. I was thinking along the lines of the following but I don't believe this syntax will work: function|strstr(userName0, right("\")). I know the function strstr expects the format strstr(string,string), and the right function expects right(string, long). Hmm.... maybe if I put it in this format? function|right($username0$, strstr($userName0$, "\")) Anyone else want to chime in? Thanks! Chris _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
