Regex : should be simple .... but my luck looking for examples been successful

Question

I have a field.  Call the field   [Original Value]   for the sake of discussion.   It has text values.

Data in field is inconsistent. So I want to catch any record with a value that has the letters    IME   anywhere in it,

Then replace the entire value in that record in the field with :    IME Exp

That's it, that's all, but I do want to do it with Regex.

Help?   Thanks in advance.

TravisR · Accepted Answer

If I'm understanding correctly - you want to replace the entire string containing "IME Exp" right? Not just the 'IME' portion with "IME Exp"?

If that's the case then put your regex tool in the Replace mode and use .*IME.* as your regular expression and "IME Exp" as the replacement text.