4 Replies Latest reply on Jan 24, 2013 10:06 AM by Peter Spier

    GREP Apply All Caps to Letter

    GeofferyH Level 1

      I have addresses that look like:

       

      1234 Addresshere 1st Ave, Apt #4b, or Apt 4b (without the # sign).

       

      I want the b in 4b to be uppercase (B). I did a find/change that looked for a digit followed by a number and change the number to uppercase, only it also found st in 1st (Ave), nd in 2nd, rd in 3rd and so on.

       

      How do I omit the "st", "nd", "rd", and "th" in the search? Do I use a negative lookbehind?

       

      TIA,

       

      Geoff