[SA 6.4.199 preview] Code search&replace

[SA 6.4.199 preview] Code search&replace

How do I use a grouped regular expression? What is the syntax for backreference? Also, what does the option Protect object names do?

You should be able to use standard syntax for regular expressions. I'm not sure what you mean by grouped. Could you please provide more details.

The Protect option will spare names in ALTER PROCEDURE [name] code, and will replace in the bodies only. This applies to views and functions too.

	SysOp wrote:
	YouThe Protect option will spare names in ALTER PROCEDURE [name] code, and will replace in the bodies only. This applies to views and functions too.

That makes sense, thanks.

	SysOp wrote:
	You should be able to use standard syntax for regular expressions. I'm not sure what you mean by grouped. Could you please provide more details.

Sure. I wanted to replace "([\s='])dbname_to_replace" with "\1new_db_name". The search part was processed properly but the replace part was inserted literally: "\1" was not replaced with the captured group. I tried "$1" as well, alas, to no avail.

Oh, I see. I'm sorry, but the regular expressions are only used for the text matching for the search operations. Presently, only a static string can be used as a replacement.

But you plan to extend that to fully support regular expressions, both in search and replace parts, don't you?