Just use the REPLACE function. It's exactly what you're looking for. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Tuesday, December 22, 2009 10:26 AM To: arslist@ARSLIST.ORG Subject: Removing a particular word in string
Hi List Does anyone know the Function for removing a particular word from a string? Can I use ltrim or substr to achieve my goal? Set: DomainA/jkelley computerx/administrator DomainA/jdoe computerx/administrator I need to remove anything that says DomainA to appear as: jkelley computerx/administrator jdoe computerx/administrator Thanks JK ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.