Hi Joe & Karthik I created REPLACE($Field$, SUBSTR($Field$, STRSTR($Field$, "<"), STRSTR($Field$, ">")), "")
This replaced the first string <font> but did not replace the second string </font>. Am I missing something? Mark From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Friday, September 14, 2012 3:23 PM To: [email protected] Subject: Re: REPLACE question ** Yes I prefer nested too instead of 2 or 3 set fields.. as its probably a more optimal way of processing the calculation instead of calculating, and writing the results to a temp field and calculating and writing the results again and again.. Joe From: Karthik<mailto:[email protected]> Sent: Friday, September 14, 2012 3:19 PM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Re: REPLACE question ** yes, nested operation in a set field works. i have done this myself earlier. -Karthik On 15 September 2012 00:47, Joe Martin D'Souza <[email protected]<mailto:[email protected]>> wrote: ** Or another supported way with about a 2 or 3 step set field operation would be to STRSTR the start and end position, then SUBSTR that string, and then REPLACE it.. You could do it in a nested operation with a single set field.. Joe From: Jose Manuel Huerta Guillén<mailto:[email protected]> Sent: Friday, September 14, 2012 1:46 PM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Re: REPLACE question ** You can use Regular Expressions to achieve it. Remedy doesn't have Regex by default, but you can access them using one of the next two tricks: 1.- You can use Regex using a direct SQL and using a SELECT that computes the regex. Oracle has Regex, and I think that MS SQL also has. 2.- Install a filter-plugin to use Regex, like this one: https://communities.bmc.com/communities/thread/53307?start=0&tstart=0 Another option is to create a filter guide with a loop to detect the patter erase it and substitute by your own. Misi is an expert doing such things. It remain at Remedy, but is harder to do and slower to compute. Jose Manuel Huerta http://theremedyforit.com/ On Fri, Sep 14, 2012 at 7:04 PM, Brittain, Mark <[email protected]<mailto:[email protected]>> wrote: there is I have not figured out the syntax _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ ________________________________ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
