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]> 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 <[email protected]> > *Sent:* Friday, September 14, 2012 1:46 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* [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]>wrote: > >> there is I have not figured out the syntax > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
