Joe, Once again... I will have to "vote" (er.. promote) the idea of using the Java Scripting Plugin. You can get to a real ( Java) programming language with full Regular Expressions so you can do this task.. and many others too.
See previous posts for URLs to the BMC developers site for download information. The download even comes with a working example of how to do RegEx stuff easily and very generically. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Fri, Mar 28, 2008 at 6:00 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote: > ** > > Has anyone implemented the equivalent of the Oracle TRANSLATE function in > Remedy? > > I have a field where I wish to translate all the alpha characters into lets > say ^ and then replace ^ with null to make that field free of alpha > characters. > > The only way I can think it is possible right now is to have a nested > REPLACE for each character. Any other method? > > I have been asked to avoid direct SQL's as far as I can so I'm going to > resort to Direct SQL as a last resort option.. > > Thanks Thad for responding to that one.. Maybe you know the answer to this > one too :-). Unfortunately on this gig I do not have that much of a luxury > to 'try' it out' > > Cheers > > > Joe D'Souza __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
