Actually if you're sure that 6 characters will be the max length of the word(s) you are looking for just substring for all 6 characters and due an rpad to trim the space if the word returned is 5 characters. Rpad(SUBSTRC($Description$, 12, 16))
Of course the command may not be rpad but there should an equivalent that I am too lazy to look up at the moment. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Friday, March 26, 2010 3:16 PM To: [email protected] Subject: SUBSTRC on the third word ** HI All I have a situation where I need to grab the third word from a description. I was able to do SUBSTRC($Description$, 12, 16) when the first three words were always the same length. However now that "third word" might be 6 characters long instead of 5. Have a great weekend Mark ____________________________________________ Mark Brittain Remedy Developer NaviSite [email protected] (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
