2 Replies Latest reply: Feb 6, 2014 8:14 AM by Mike Kemp RSS

    REGEX search and replace

    Mike Kemp

      In the version of SQL Developer I had before this one (4.0.0.12.84 maybe?) I could do a search and replace like this:

       

      ==============================================================

      Replace Text:


      Text to Search For: \n

       

      Checked: Replace With: '\n     'Hello

      Checked: Regular Expressions

      Checked: Selected Text Only

       

      Direction:

      Forward

      Scope:

      All

      ==============================================================


      This would replace the following text:

       

      fancy code

      more fancy code

      code only a Mensa could write

       

      ... with ...

       

      fancy code'

          'Hello more fancy code'

          'Hello code only a Mensa could write

       

      NOW - the same Search and Replace replaces the original code with the following:

       

      fancy code'     'Hello more fancy code'     'Hello code only a Mensa could write

       

      So, yeah, not good Feng Shui at all.

       

      4.0.0.13 Build MAIN-13.80

       

      Thank you.