<div>
This should do the trick, including keeping the EOL characters currently used:<br />

<pre><code class="code-1 nolinks" id="code-20-41737582-1"><span>$Sql = [IO.File]::ReadAllText(&quot;C:\Temp\test.sql&quot;)</span>
<span>$Sql -replace &quot;(?s)($([regex]::Escape('REFERENCES [T_test] ([Id])')))(\r?\n)(GO)&quot;, '$1$2NOT FOR REPLICATION$2$3'</span>
</code></pre>
</div>


<div>
Ok thanks sorry my question is not clear. I search to add not for replication for any alter table.
</div>


<div>
Even shorter:<br />

<pre><code class="code-1 nolinks" id="code-20-41737636-1"><span>$Sql = [IO.File]::ReadAllText(&quot;C:\Temp\test.sql&quot;)</span>
<span>$Sql -replace '(?s)(ALTER TABLE .*?)(\r?\n)(GO)', '$1$2NOT FOR REPLICATION$2$3'</span>
</code></pre>
</div>


<div>
Thanks but syntax error is generated for alter table check constraint.<br />
I add option NOT FOR REPLICATION only for ALTER TABLE ... FOREIGN KEY ...<br />
I try :<br />
-replace '(?s)(ALTER TABLE .*? FOREIGN KEY .*?)(\r?\n)(GO)', '$1$2NOT FOR REPLICATION$2$3'<br />
But the replace isn't done.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I search how I can modify a txt file containing :<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-28960766-1"><span>ALTER TABLE [dbo].[T_tbl]  WITH CHECK ADD  CONSTRAINT [FK_T_tbl_t_test] FOREIGN KEY([proc])</span>
<span>REFERENCES [T_test] ([Id])</span>
<span>GO</span>
</code></pre>
<br />
by<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-28960766-2"><span>ALTER TABLE [dbo].[T_tbl]  WITH CHECK ADD  CONSTRAINT [FK_T_tbl_t_test] FOREIGN KEY([proc])</span>
<span>REFERENCES [T_test] ([Id])</span>
<span>NOT FOR REPLICATION</span>
<span>GO</span>
</code></pre>
<br />
Thanks<br />
<br />
Regards
</div>
</div>


Hello,

I search how I can modify a txt file containing :

(CODE)

by

(CODE)

Thanks

Regards

add NOT FOR REPLICATION in a txt file

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.