I don't know what version ARS you are using.. But I was Bug;s listed in the
Docs for P4 concerning this ..
SW00265515
Carriage returns for STRSTR and SUBSTR functions are handled
differently by Internet Explorer, Firefox, and BMC Remedy User.
On 8/22/07, Opela, Gary L Contr OC-ALC/ITMA <[EMAIL PROTECTED]>
wrote:
>
> Okay, here's what to do. To find more expanded syntax, check out a post
> I posted yesterday about table fields.
>
> Save the string1 in a tmpstring field
> Use STRSTR to find the index of the , then use SUBSTR to cut off the
> first value. Compare it to string 2 to see if it's in there.
>
> In your below example, you would see:
>
> String1 = "20070821-001, 20070821-002, 20070821-002-A, 20070821-003, "
>
> The first iteration, tmpstring = "20070821-001, 20070821-002,
> 20070821-002-A, 20070821-003, "
> Now, take the SUBSTR($tmpstring$,0,STRSTR($tmpstring, ",")) or something
> like that to grab just the first token, 20070821-001. Compare that to
> string2, if it doesn't match, then set tmpstring =
> SUBSTR($tmpstring$,STRSTR($tmpstring$,",")) which would now give you a
> new value of: tmpstring = "20070821-002, 20070821-002-A, 20070821-003, "
>
> Then just iterate until either tmpstring = $NULL$ or until you find your
> value.
>
> By breaking up each token based on the comma, you can do a literal
> compare so you don't run into the problem of it matching both string2
> and string3 whenever it finds string3.
>
> You will probably need to use LTRIM and/or RTRIM also.
>
> Thanks,
>
>
> Gary Opela, Jr
>
> Sr. Remedy Developer
>
> Leader Communications, Inc.
>
> 405 736 3211
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane
> Sent: Wednesday, August 22, 2007 10:14 AM
> To: [email protected]
> Subject: Repost: Wildcard in STRSTR function?
>
> I couldn't find this post on the web server, so I thought I'd r
> Folks:
>
> I couldn't find this post on the web server, so I thought I'd repost it.
> Any thoughts on this?
>
> Thanks,
> --Phil
>
> ----- Forwarded Message ----
> From: Phil Murnane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: Phil Murnane <[EMAIL PROTECTED]>
> Sent: Tuesday, August 21, 2007 10:32:23 AM
> Subject: Wildcard in STRSTR function?
>
>
> Folks:
>
> Has anyone ever used a wildcard as the secnd parameter in a STRSTR()
> function? I'm trying to test whether string2 exists in string1, where
> string2 may be a substring of string3 also in string one. This is
> similar
> to finding a Group ID in a $GROUPIDS$ result.
>
> Example:
> ARS 6.3
> string1 = ", 20070821-001, 20070821-002, 20070821-002-A, 20070821-003, "
> string2 = "20070821-002"
> string3 = "20070821-002-A"
>
> I can't just use STRSTR(string1, string2) because even if string1 did
> not
> contain string2 this function would erroneously find the value, since
> string2 is a substring of string3.
>
> Here's my syntax:
> zScratchInteger = STRSTRC($string1$,(" %, " + $string2$ ) + ", %")
>
> But this always returns -1 -- it never finds string2 in string1.
>
> Is this because of the wildcard percent signs?
>
> TIA,
> --Phil
>
>
>
> ________________________________________________________________________
> ____________Ready for the edge of your seat?
> Check out tonight's top picks on Yahoo! TV.
> http://tv.yahoo.com/
>
> ________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
--
Patrick Zandi
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
