Try using LEFT($MDA-Organization$, (STRSTR($MDA-Organization$, "/")-1)) instead of SUBSTR
It slmost sounds like the field you are trying to put the value into is not a string. If it still has problems you can use: REPLACE(LEFT($MDA-Organization$, STRSTR($MDA-Organization$, "/")), "/", "") Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Charlie CTR MDA/DOCC Sent: Tuesday, February 12, 2008 11:55 AM To: [email protected] Subject: Re: Truncating a string value (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Hiya J.T., Whenever I add this: SUBSTR($MDA-Organization$, 0, (STRSTR($MDA-Organization$, "/")-1)) to the value field in my escalation, it is automatically changed when I hit the Modify Action button. Here's what it changes to: SUBSTR($MDA-Organization$, "Proposed", STRSTR($MDA-Organization$, "/") - "Enabled")) As you can imagine, when the escalation runs, it's throwing errors whenever it gets to that field... any idea what's going on there? Charlie Bennett Remedy Administrator Missile Defense Integration & Operations Center Schriever AFB Colorado Springs, CO (719) 721-7470 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, February 12, 2008 7:25 AM To: [email protected] Subject: Re: Truncating a string value (UNCLASSIFIED) Whoops...small mistake. It should be: SUBSTR($field$,0,(STRSTR($field$,"/")-1) Replace $field$ with whatever field you are truncating. In short, this works like so: SUBSTR returns a string made from the first argument starting at the position of the second argument (0 is the first character) going to the third argument. So, SUBSTR("Hello",0,1) would return He for example. The STRSTR function finds the first occurrence of a character inside another. In this case, find the / in the field. Example, STRSTR("Hello","l") would return 2. We use them together: SUBSTR("Hello",0,(STRSTR("Hello","l")-1) Would return: He Hope that helps! J.T. Shyman Column Technologies -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, February 12, 2008 9:20 AM To: [email protected] Subject: Re: Truncating a string value (UNCLASSIFIED) Try this: SUBSTR($field$,1,(STRSTR($field$,"/")-1) J.T. Shyman Column Technologies -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Charlie CTR MDA/DOCC Sent: Tuesday, February 12, 2008 9:12 AM To: [email protected] Subject: Truncating a string value (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Hi Everyone, Here's a AR 7.0.01 Service Desk question: I have a vendor form that I'm using to populate my people records with, and I need to mine some data out of one of the fields. One of the fields is an Organization field that contains an org's acronym (which can be anywhere from two to four characters long). The way things work, is that the people form has a drop-down list of all the possible orgs' acronyms, and based on what's coming from the vendor form, it syncs with one of the possible choices. The problem is that I'm seeing a handful of people who are members of multiple orgs. When my nightly escalation runs, it leaves the multiple-org peoples' org fields blank because there's no matching org in the drop-down list. Instead of rethinking the entire escalation, is there a way to truncate the string coming from the vendor form in such a way that I can grab just the first org? Here's how it looks when a person has mulitple orgs: ICEI/DOCC/DOCO The multiple orgs are delineated with forward slashes. Is there a way to sniff for the first forward slash, and then grab whatever came before it? That way, I can simply populate the people record with their first org acronym. Thanks in advance! Charlie Bennett Remedy Administrator Missile Defense Integration & Operations Center Schriever AFB Colorado Springs, CO (719) 721-7470 Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
