Search Replace, Regular Expressions...

Alright,
I've tried every manner available to my knowledge, and I can't get BackReferences to work. There is absolutely no point whatsoever to code the ability to use Regular Expressions in search/replace functions unless you can use back references in the replacement text.

I'm using PL/SQL Developer 7.0.3.1123, as we don't have the license for 7.1, and I am doing a simple search & replace:

Search: ^(!echo(.)*)
Replace: /* $1 */

I've tried dollar-sign ($) syntax, i've tried backslash (\) syntax and nothing works. I want to leave the line text alone, i just want to comment out every line that starts with !echo. This is because a lot of my coworkers write their sql via a CRT telnet window to the linux server, where as I use PL SQL Developer. PLSQL doesn't recognize the !echo command, so I need to comment them all out.

It is a royal pain to have to copy and paste the entire file every time i need to do a search replace that utilizes regular expressions just because I can't find out how to utilize back-references in PL SQL developer. If anyone knows how I can use this fundamental technology, please let me know, because this is rather frustrating.

Regards

Jaeden "Sifo Dyas" al'Raec Ruiner
 
There is indeed no support in the replacement text for this. It is on the list of enhancement requests though.
 
Would this work for you?

Search: !echo
Replace: -- !echo

I know it's not the same comment style, but it seems simpler.

Mike
 
Back
Top