Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 17.3.1 search/replace with newline "\n" doesn't work

eladnerNov 28 2017 — edited Nov 28 2017

When using \n in a replacement pattern in 17.3, it doesn't correctly insert the newline character, even if "Substitute Escaped Characters" is turned on.

For example, replacing "(     *)" with "\n$1" results in "          " being replaced with "n            ".

Toggling the "Substitute Escaped Characters" button doesn't change this behavior either way (on or off - same behavior).

Java 1.8.0_144 on Windows 10.  Confirmed also on Ubuntu 16.04 (current JDK) and even SQL Developer 4.2.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2017
Added on Nov 28 2017
#sql-developer
2 comments
791 views