Regex tester
Pattern
Input
create function [SN].[FunctionName]   test1 test1 ...
create function SN.FunctionName   test2 test2 ...
create function functionName   test3 test3 ...
Options
Replacement
Click the context tab to see replacements.
2 matches found in about 9 milliseconds.
IndexPositionMatched String${name}
00create function [SN].[FunctionName][SN].[FunctionName]
155create function SN.FunctionNameSN.FunctionName
create function [SN].[FunctionName]   test1 test1 ...
​create function SN.FunctionName   test2 test2 ...
​create function functionName   test3 test3 ...
  1. empty string
  2. [SN].[FunctionName]
  3. test1 test1 ...
  4. SN.FunctionName
  5. test2 test2 ...
    create function functionName test3 test3 ...