I have a similar problem as Wayne had the other day. I need to build a dictionary for the Title1 Field. it reads in part:
Replacement Value 1: Mr.
Value to match on 1: Mr
Replacement Value 2: Ms.
Value to match on 2: Ms
Replacement Value 3: --Blank--
Value to match on 3: Anything else (e.g. random characters: "A" or "M." or "CFO" etc )
I tried the following RegEx expression: ^(?!(Mr|Ms|Dr|Sr|Mrs)\.$).*
But this does not work. Does anybody have a better solution?
I think you want it to say something like:
If, by this point, it finds the correct version of the text, then look for "MATCHED" in that string (which doesn't exist) and replace that part with -BLANK- (so basically do nothing). Otherwise, replace the whole string with -BLANK-
That's how I understand it at least...