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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
