search and replace with regular expression

malin

Member
Hello,

I use a regular expression pattern to add quotation marks to strings. It works in other text editors but it does not work in pl/sql developer. Example:

text pad:
find: ^.*$
replace: ,'&'

notepad ++:
find: ^(.*)$
replace: ,'\1'

What should I type in replace field to make it working in pl/sql developer?

Regards,
malin
 
The replacement text does indeed not support regular expressions. This is on the list of enhancement requests.
 
I would suggest doing it in two stages:

find: ^
replace: ,'
find: $
replace: '

However, pl/sql developer does not appear to support this. The "find" part works but the "replace" part doesn't. Perhaps adding support for this would be significantly quicker and easier?
 
Back
Top