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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"